All,
I need some help writing some queries for a MTM relationship. The example
tables are:
author table books table author_books table
author_id PK book_isbn PK a_b_id PK
author_fname book_title author_id FK
author_lname book_pub_date book_isbn FK
author_minit
Listings desired:
book_isbn book_title book_pub_date author
----------+------------+--------------+-----------
author book_isbn Book_title
--------+-------------+------------
Would appreciate the query (inner join - that I do know), and why so I can
learn something from them. Please keep them simple (no alias or other
shortcuts) so I can easily follow what you are doing. Thanks in advance.
I assume the query will be something like:
SELECT
books.book_isbn, books.book_title, books.book_pub_date,
author.author_fname, author.author_minit,
author.author_lname
FROM books
JOIN
author_books ON (something )
Dave,
Sent with ProtonMail Secure Email.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
