~/ learn/ postgresql/ cards/ Joining Tables
1 of 10

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/271cbe26-9289-4b00-9011-e9ea31624798/flashcard utf-8 LF