~/ learn/ postgresql/ cards/ INNER JOIN: combining tables
1 of 2

Show each book's title alongside its author's name. Columns: title, name.

Show each book's title alongside its author's name. Columns: title, name.

Answer

SELECT b.title, a.name FROM books b JOIN authors a ON b.author_id = a.id;

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/3c397614-a11c-4455-bb83-30c3bb83d27e/flashcard utf-8 LF