Joining tables

[zzz]

I need to join a table and usually use LEFT JOIN but in this particular case I nee to be able to join table based on several parameters. Here's what I've tried:

SELECT * FROM t1
LEFT JOIN t2 ON (t1.1= t2.A
t1.2= t2.B AND
t1.3= t2.C)

Can I do that?

The reason I have to do that way because I'm trying to extract a value from t2 when a record in t2 matches 3 records in t1.

For example: I need to get home phone number from t2, which is not in t1. In order to do that I need to match First, Last names and home address.

Individually I can have other users with the same name (first or last) in t2. At the same time I can have other names at the same address...

[bastien]

select t1.* from
t1 inner join t2 on t1.field = t2.field
inner join t3 on t1.field2 = t3.field2
where clause...

[zzz]

...I only have 2 tables...

My problem is that I need to use 3 parameters to join the table. Can I do something like:

select t1.* from t1
inner join t2 on t1.field = t2.field
inner join t2 on t1.field2 = 2.field2
inner join t2 on t1.field3 = 2.field3

[zzz]

Still need to figure this one out!!! 🙁

[bastien]

no, you need two parameters to join the table, you HAVE three parameters in the where clause...simply add the parameters to the where clause

[zzz]

dah... I'll try it now.