On Sat, Jan 10, 2009 at 02:58:57PM +0100, Lukas Haase wrote: > > What is it that you think a LEFT JOIN does? > > (A LEFT JOIN B) joins together table A and B while all records are taken > from A and only records that match both are takes from B. If a record > from A has no corresponding data in B, the values are NULL.
That's what a LEFT JOIN is, but why do you think you need it? > > How is > > a LEFT JOIN different than an ordinary inner JOIN? > > INNER JOIN takes *all* records from both tables, A and B. Generally, the > resultset will be larger. The result of an INNER JOIN will be smaller than or equal to that of a LEFT JOIN since rows from A that can't be joined to any rows from B don't appear in the result of the INNER JOIN but do appear in the LEFT JOIN. Were you thinking of cross joins? Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users