TSQL Select from merged files syntax

[Tomadams]

Hi,

I need to select every record in one file, if one field is found in either one of two files the logic is simple

Select table1.* if table1.model = either table2.model or table3.name.

I think I need to merge the key fields from table2 and table3, then select my records from table1.

Can anyone help with the syntax?

Thanks, Tom