how can i join twice two mysql tables...
Posted: Tue Oct 25, 2005 6:43 am
hello ! i need to join twice two mysql tables and i don't know how.What i want to do looks something like this:
SELECT *
FROM emails
left JOIN personen ON emails.id_person = personen.id
left JOIN themen ON emails.id_thema = themen.id
left join login on emails.id_berater=login.id
left join login on emails.id_supervisor=login.id
except that i cannot join with login.id twice.What would the solution be?
SELECT *
FROM emails
left JOIN personen ON emails.id_person = personen.id
left JOIN themen ON emails.id_thema = themen.id
left join login on emails.id_berater=login.id
left join login on emails.id_supervisor=login.id
except that i cannot join with login.id twice.What would the solution be?