Why is the MySQL query giving me this?

[anicolais]

This is my query:
SELECT accounts_cstm.result_status_c AS 'Result Status', accounts_cstm.result_status_date_c AS 'Result Status Date', accounts.name AS 'Company Name', accounts.billing_address_city AS 'Company City', accounts.billing_address_state AS 'Company State', contacts.last_name AS 'Contact Name', contacts.phone_work AS 'Contact Phone', "" AS 'Email', (contacts_cstm.appointment_set_c + contacts_cstm.time_and_timezone_c) AS 'Appointment', accounts_cstm.list_source_c AS 'List Source', accounts_cstm.primary_markets_c AS 'Primary Markets', accounts_cstm.company_size_c AS 'Company Size', accounts_cstm.actual_result_c AS 'Actual Result', accounts_cstm.dollar_amount_c AS 'Dollar Amount', notes.description AS 'Notes'
FROM contacts LEFT JOIN accounts_contacts ON contacts.id = accounts_contacts.contact_id
LEFT JOIN accounts ON accounts.id = accounts_contacts.account_id
LEFT JOIN accounts ON accounts.id = accounts_cstm.id_c
LEFT JOIN contacts ON contacts.id = contacts_cstm.id_c
Left Join contacts on contacts.id = notes.id

Its giving me Not unique table/alias: 'accounts' Huh???????

Sugar 5.5
MySQL

[Angel]

This is my query:

LEFT JOIN accounts ON accounts.id = accounts_cstm.id_c
LEFT JOIN contacts ON contacts.id = contacts_cstm.id_c

Its giving me Not unique table/alias: 'accounts' Huh???????

Sugar 5.5
MySQL

The above should be JOIN accounts_cstm and JOIN contacts_cstm

Also, you are joining the contacts table in your last line, although your original FROM is on the contacts table. I think what you want in that case is a JOIN notes.

[anicolais]

Wowww duhh definitely staring at this way to long today....Thank you very much!