Simon Slavin wrote: > On 7 Jul 2016, at 3:37pm, Josef Kučera <jokusoftw...@gmail.com> wrote: >> Imagine a query like "SELECT A.F1, B1.F FROM A JOIN (SELECT F2 AS F FROM B >> WHERE F3=0) B1". > > your natural JOIN is a little dangerous since it can collapse if you > change column names or definitions.
A natural join would be written NATURAL JOIN. This is a cross join. > It's better to define the connection between the two tables explicitly. > I would hope to see something more like > > SELECT A.F1, B.F FROM A JOIN B ON B.x = A.y And if the column names are the same (which would always be the case if the original query actually used a natural join), using USING would be even simpler: SELECT ... FROM A JOIN B USING (SomeID) Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
