Help with complex SQL query

[aheuermann]

I am looking to create a query that ouputs the all the contacts exactly how they are in th list view.
For every contact I want their last_name, first_name, title, email1, phone_work, and the name of the account(if they are associated with one).

The accounts_contacts table is used to link any contacts to their corresponding account. I can get it to output all contacts who are assigned to an account, but I cant get it to output a list of all contacts that, if associated with an account, it is listed otherwise it is listed as Null.

Thanks in advance for any help.

[stevec]

This should do it - 'outer joins' are your friend...

SELECT
contacts.last_name,
contacts.first_name,
contacts.title,
contacts.email1,
contacts.phone_work,
accounts.name
FROM
contacts
Left Outer Join accounts_contacts ON contacts.id = accounts_contacts.contact_id
Left Outer Join accounts ON accounts_contacts.account_id = accounts.id

[aheuermann]

Thank you very much!!!