help with a query

[EyeTalion]

I have two tables, each with three fields. Each table has a vendor field, but there not going to be identical. I need to search through the vendors if I can find a partial match. I've tried...

SELECT table1.vendor, table2.vendor
FROM table1, table2
WHERE table1.vendor = '%table2.vendor%'

I put in a dummy field that I knew would match just to make sure, but it still didn't return anything...any advice?

thanks,
eye

[BruceG]

use LIKE instead of the =

[Tailgun]

SELECT table1.vendor, table2.vendor
FROM table1, table2
WHERE table1.vendor = '%table2.vendor%'

Try using Like instead of =

WHERE table1.vendor Like '%table2.vendor%'

[EyeTalion]

I've tried that too. Doesn't return anything and I have a dummy record in there that should get returned


eye

[Doe maar]

try this then

SELECT table1.vendor, table2.vendor
FROM table1, table2
WHERE table1.vendor like '%'+table2.vendor+'%'

[EyeTalion]

hey doe, tried that query...it just keeps running....