[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Query for Many to Many
From:       David Raymond <David.Raymond () tomtom ! com>
Date:       2019-08-27 14:52:13
Message-ID: VI1PR07MB5792A14A7D71F4FEB3C39A9E87A00 () VI1PR07MB5792 ! eurprd07 ! prod ! outlook ! com
[Download RAW message or body]

It does support natural joins. <Insert usual "be careful with schema changes" comments here>

USING needs parenthesis around the column list: ...using (author_id)...using (book_isbn)...


-----Original Message-----
From: sqlite-users <sqlite-users-bounces@mailinglists.sqlite.org> On Behalf Of Dominique Devienne
Sent: Tuesday, August 27, 2019 10:08 AM
To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Subject: Re: [sqlite] Query for Many to Many

On Tue, Aug 27, 2019 at 4:00 PM Dominique Devienne <ddevienne@gmail.com>
wrote:

> select author.*, books.*
>   from author_books
>   join author on author.author_id  = author_books.author_id
>   join books  on books.book_isbn   = author_books.book_isbn
>

Which can also be written:

select author.*, books.*
  from author_books
  join author using author_id
  join books  using book_isbn

Or even:

select author.*, books.*
  from author_books
  natural join author
  natural join books

All of the above untested of course :).
Not even sure SQLite supports natural join or not (I'd guess it does). --DD

https://stackoverflow.com/questions/45531762/sql-join-using-vs-join-on
https://stackoverflow.com/questions/8696383/difference-between-natural-join-and-inner-join
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[prev in list] [next in list] [prev in thread] [next in thread]