SQL - LEFT and RIGHT JOIN
Consider these tables:
id | name
1 | John
2 | Mary
author_id | title
1 | SQL Basics
1 | Advanced SQL
What will this query return?
Authorsid | name
1 | John
2 | Mary
Booksauthor_id | title
1 | SQL Basics
1 | Advanced SQL
What will this query return?
SELECT Authors.name, Books.title FROM Authors LEFT JOIN Books ON Authors.id = Books.author_id WHERE Books.title = 'SQL Basics';