How do I join (SQL) two fields that are similar not same

[cousinconley]

I have two tables in Access I am trying to join. I cant remember the SQL. Both fields are text fields. One field contains a vendor name. The field from the other table is a description that contains the vendor name. What is the SQL to join or select using contains?

 

[tlbroadbent]

This is the syntax that should work.

Select
table1.colA, table1.colB, ...
table2.colA, table2.colB, ...
From table1, table2
Where table2.vendordesc Like "*" & table1.vendorname & "*" Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums. NOTE: Reference to the FAQ is not directed at any individual.

 

[cousinconley]

THANKS!!!