MySQL Forums
Forum List  »  Docs

no documentation on JOIN syntax (par. 13.2.7.1 is empty)
Posted by: Patrick Ploum
Date: January 31, 2006 12:04PM

I need some information on the LEFT JOIN syntax. However, the relevant paragraph in the on-line manual is an empty page (versions 4.1., 5.0 and 5.1). I am specifically looking for the reason why the following will not work:

SELECT * FROM table1 LEFT JOIN table2 ON table2_id=table1_fk ORDER BY table2_somefield

where table1_fk is the foreign key refering to the key (table2_id) in table2.

(e.g. SELECT * FROM orders LEFT JOIN customers ON customer_id=customer_fk ORDER BY customer_city, to display all customer orders sorted on customer city)

Options: ReplyQuote


Subject
Views
Written By
Posted
no documentation on JOIN syntax (par. 13.2.7.1 is empty)
4031
January 31, 2006 12:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.