On 6 Sep 2019, at 7:36am, Rowan Worth wrote:
> I was surprised when this behaved differently in other SQL engines. eg. in
> SQLite you can write:
>
> SELECT col1, col2 FROM table1, table2 USING
But please don't, for the reason you gave. Not only is it ambiguous but
different SQL engines
On Tue, 3 Sep 2019 at 22:17, Keith Medcalf wrote:
> And the "," in the list of tables may be replaced by the word JOIN. It is
> merely an alternate spelling.
>
I was surprised when this behaved differently in other SQL engines. eg. in
SQLite you can write:
SELECT col1, col2 FROM table1,
" comments here>
>> > USING needs parenthesis around the column list: ...using
>> > (author_id)...using (book_isbn)...
>> > -Original Message-
>> > From: sqlite-users sqlite-users-boun...@mailinglists.sqlite.org On
>> > Behalf Of Dominique Devienne
&g
author_id)...using (book_isbn)...
> > -Original Message-
> > From: sqlite-users sqlite-users-boun...@mailinglists.sqlite.org On
> > Behalf Of Dominique Devienne
> > Sent: Tuesday, August 27, 2019 10:08 AM
> > To: SQLite mailing list sqlite-users@mailinglists.sqlite
;
>
> USING needs parenthesis around the column list: ...using
> (author_id)...using (book_isbn)...
>
>
> -Original Message-
> From: sqlite-users On
> Behalf Of Dominique Devienne
> Sent: Tuesday, August 27, 2019 10:08 AM
> To: SQLite mailing list
>
It does support natural joins.
USING needs parenthesis around the column list: ...using (author_id)...using
(book_isbn)...
-Original Message-
From: sqlite-users On Behalf Of
Dominique Devienne
Sent: Tuesday, August 27, 2019 10:08 AM
To: SQLite mailing list
Subject: Re: [sqlite
On Tue, Aug 27, 2019 at 4:00 PM Dominique Devienne
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
On Tue, Aug 27, 2019 at 3:38 PM dboland9 wrote:
> I need some help writing some queries for a MTM relationship. The example
> tables are:
>
> author table books table author_books table
> author_id PKbook_isbn PKa_b_id PK
> author_fnamebook_title
The basic query is going to be the below
select stuff
from
books
inner join author_books
on author_books.book_isbn = books.book_isbn
inner join author
on author_books.author_id = author.author_id
where things;
-Original Message-
From: sqlite-users On Behalf Of
dboland9
9 matches
Mail list logo