On Thu, Oct 14, 2010 at 1:05 PM, Alan Chandler <a...@chandlerfamily.org.uk>wrote:
> I seem to be doing plenty of > > SELECT * FROM a LEFT JOIN b WHERE ...; > > but looking at the syntax diagrams at > > http://www.sqlite.org/lang_select.html > > it looks like I have to follow LEFT with OUTER. > > Shouldn't the diagram allow OUTER to be bypassed? > Up until recently, the syntax diagram was this: http://www.sqlite.org/docsrc/artifact/21606e4a148231cb739bffb698dd746b49b79a99 But that diagram allowed things like OUTER JOIN or NATURAL OUTER JOIN, which do not work in SQLite. So the diagram was changed to http://www.sqlite.org/docsrc/artifact/8d36306fc0388a51444e35f98369d29b35a005a2 But, as you observe, this new diagram precludes LEFT JOIN. So it has now been revised again to: http://www.sqlite.org/docsrc/artifact/21606e4a148231cb739bffb698dd746b49b79a99 Your code is correct. > > -- > Alan Chandler > http://www.chandlerfamily.org.uk > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users