SQL - LEFT and RIGHT JOIN
Consider tables:
ID | Name
1 | Alice
2 | Bob
ID | AuthorID | Title
10 | 1 | Book A
11 | 3 | Book B
What will this query return?
Authors:ID | Name
1 | Alice
2 | Bob
Books:ID | AuthorID | Title
10 | 1 | Book A
11 | 3 | Book B
What will this query return?
SELECT Authors.Name, Books.Title FROM Authors LEFT JOIN Books ON Authors.ID = Books.AuthorID;