Hi Clemens, You're right. I didn't look into your SQL carefully enough. As a reference, in MySQL the table of id would be the first table it belongs to. `articles` it is.
Jake > On 15 Jan 2018, at 11:03 PM, Clemens Ladisch <[email protected]> wrote: > > Jake Chen wrote: >>> On 15 Jan 2018, at 9:14 PM, Clemens Ladisch <[email protected]> wrote: >>> SELECT id FROM articles JOIN tags USING (id); >> >> `id` is ambiguous here. > > It's not, because of the USING clause. > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
