Need SQL Code HELP

[kschuster]

How do I make this select pull a secod value from the table DROPLIST? If I add another LEFT OUTER JOIN droplist ON (client.how_apply = droplist.id)

I get an error. How do I do two separate joins to the same table in MySQL?

Thanks

SELECT managers.managerid,
managers.mgr_email,
managers.mgr_name,
managers.mgr_office,
managers.mgr_phone,
client.coid,
client.eng_no,
client.coname,
client.managerid,
client.title,
droplist.value as fee_how_apply,
droplist.name

FROM client
LEFT OUTER JOIN droplist ON (client.Fee_how_apply = droplist.id)

LEFT OUTER JOIN managers ON (client.managerid = managers.managerid)
WHERE
(
(client.coid = 4644)
)

[Anon]

You need to use alias names for the tables, that way you can use the saem table more than once:

SELECT m.managerid,
m.mgr_email,
m.mgr_name,
m.mgr_office,
m.mgr_phone,
c.coid,
c.eng_no,
c.coname,
c.managerid,
c.title,
d1.value as fee_how_apply,
d1.name
FROM client c
LEFT OUTER JOIN droplist d1 ON (c.Fee_how_apply = d1.id)

LEFT OUTER JOIN managers m ON (c.managerid = m.managerid)
LEFT OUTER JOIN droplist d2 ON ...whatever...
WHERE
(
(c.coid = 4644)
)