no documentation on JOIN syntax (par. 13.2.7.1 is empty)

[Patrick Ploum]

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)