SQL & PL/SQL

Hello....

I'm receiving the 01417 error on the query listed below, and I understand why but am finding myself stumped at finding a work-around. The problem is with the accounts_contacts table (ac). This is basically an intersection table that was created in order to get from accounts to contacts. That's great, but because I need to outer join on both the accounts and contacts tables, when joining to this table, I get this error. Any suggestions would be greatly appreciated.

Thanks,

Christine


SELECT a.ID account_id, a.NAME account_name, c.ID contact_id, c.deleted,
c.broker_id, c.first_name, c.last_name, c.date_entered,
NVL (u.first_name || ' ' || u.last_name, NULL) AS created_by,
c.date_modified, c.email1, cc.ext_c, c.phone_fax, cc.office_c,
cc.asm_c, cc.ilo_c, c.date_last_contacted, c.primary_address_street,
c.primary_address_city, c.primary_address_state,
c.primary_address_postalcode, c.phone_mobile, c.phone_work, c.title,
acstm.bdm1_c, acstm.bdm2_c, acstm.mm_c, acstm.dm_c
FROM sugarcrm.accounts a,
sugarcrm.accounts_contacts ac,
sugarcrm.accounts_cstm acstm,
sugarcrm.contacts c,
sugarcrm.contacts_cstm cc,
sugarcrm.users u
WHERE a.ID = ac.account_id(+)
AND a.ID = acstm.id_c(+)
AND c.ID = ac.contact_id(+)
AND c.ID = cc.id_c(+)
AND c.created_by = u.ID(+)