Match two words in inner join

[punna111]

Hi All,

Please find the attachment.
In sheet 1 & 2 you have a tables.
I want to match Zip field from sheet 1 to sheet 2 (this is = match)


but where we go to name match i want match sheet 2 name1 & Name 2 that contains in sheet 1 Name field.
These three should match. Just leave about Z no.
I need a query for this. I am trying from 1 week but not getting.Book1 (2).zip

[June7]

Why do you need to join names? Is Zip unique in both tables?

Try:

SELECT Table1.*, Table2.*
FROM Table1, Table2
WHERE (((Table1.Name) Like "*" & [Table2].[Name1] & "*") AND ((Table1.Zip)=[Table2].[Zip]));