[SOLVED] Joining 1 table on 2 fields

[dc_jt]

Basically I have installer_id and revisit_installer_id

 

These are stored in the jobs table. I want to link each of these to the installer table, something like:

 

LEFT OUTER JOIN installers

      ON jobs.installer_id = installers.installer_id 

 

But I also need to join installers  ON jobs.revisit_id = installers.installer_id

 

This isnt right though. How do I do this?

 

Thanks

[Barand]

Use 2 different aliases for installer table

 

LEFT JOIN installers a

      ON jobs.installer_id = a.installer_id

LEFT JOIN installers b

      ON jobs.revisit_id = b.installer_id

 

[dc_jt]

Thanks a lot