LEFT JOIN

Question

LEFT JOIN

You are working at a bookstore and have the following tables:

authors:

id authorname
1 bruce eckel
2 robert lafore
3 andrew tanenbaum

books:

id authorid bookname
1 3 Modern Operating System
2 1 Thinking in Java
3 3 Computer Architecture
4 1 Programming in Scala

Write a query to output all authors and the books they wrote in one table (authorname-bookname).

im stuck at this question, help please

Answer 1

Where is your query?

Answer 2

This is the query you were asking:

SELECT authors.authorname, books.bookname
FROM authors LEFT JOIN books ON authors.id = books.authorid