Join on multiple fields

[hitman6003]

it's easiest if I just put up an example:

 

SELECT * FROM db

LEFT JOIN db2 ON db.field1 = db2.id

 

That works fine, but I have another field in "db" that I need to join to "db2".

 

I've tried:

SELECT * FROM db

LEFT JOIN db2 ON db.field1 = db2.id

LEFT JOIN db2 ON db.field2 = db2.id

 

And:

SELECT * FROM db

LEFT JOIN db2 ON db.field1 = db2.id, db.field2 = db2.id

 

And:

 

SELECT * FROM db

LEFT JOIN db2 ON db.field1, db.field2 = db2.id

 

 

But I get an error with each one.

 

Thanks for the help.

[sqlmc]

Try this:

 

SELECT *

FROM db

LEFT JOIN db2

ON db.field1 = db2.field1

AND db.field2 = db2.field2