i'm having difficulty joining more than two tables using the sql-92 syntax. does mysql allow nesting of joins in this way?
example:
SELECT p.last_name, p.first_name, e.e_mail_address FROM e_mail e INNER JOIN ( people_email pe INNER JOIN people p ON pe.people_id = p.id ) ON e.id = pe.email_id
i realize that this join could be written using the standard join syntax, but since MySQL doesn't support outer joins using the standard syntax i would like to get this method to work if possible.
any ideas?
example:
SELECT p.last_name, p.first_name, e.e_mail_address FROM e_mail e INNER JOIN ( people_email pe INNER JOIN people p ON pe.people_id = p.id ) ON e.id = pe.email_id
i realize that this join could be written using the standard join syntax, but since MySQL doesn't support outer joins using the standard syntax i would like to get this method to work if possible.
any ideas?