~/ 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/4475ec21-caf0-4332-98d2-9ce971aac276/flashcard utf-8 LF