Multiple joins as an "OR"

[charliej]

I have two tables, one has two phone fields and the other has four phone fields. Everything is standardized to 10 digits per field and I import them as text.

Is it possible to join them based on whether Table1.Phone1 matches ANY of Table2.Phone1, Table2.Phone2, Table2.Phone3, or Table2.Phone4 AND a one to one relationship of another field?

I know I would likely have to do a second query for Table1.Phone2 to ANY of the Table2 phone fields.

Table1:
Name - Phone1 - Phone2
John Smith - 2125551212 - 7185551212
Bob Adams - 3015551212 - 4105551212

Table2:
ID - Name - Phone1 - Phone2 - Phone3 - Phone4
123 - John Smith - 2125551212 - null - null - 7185551212
456 - Bob Adams - null - 4105551212 - null - null

Desired Result would be a mix of fields from both tables. For example:
Table2.ID Table1.Phone1 Table2.Phone2 etc.

Thanks in advance!

[r035198x]

OR should do it for the firstpart. Something like

select  t2.ID, t1.Phone1, t2.Phone2  from Table1 t1, Table2 t2
where (t1.Phone1 = t2.Phone1 or  t1.Phone1 = t2.Phone2 or t1.Phone1 = t2.Phone3 ....)
AND ...