~/ 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/720e0077-1115-4aad-9503-461c227cb549/flashcard utf-8 LF