7 lines
367 B
SQL
7 lines
367 B
SQL
SELECT
|
|
book.title AS book.title,
|
|
book$periodical.id AS book$periodical$id,
|
|
book$periodical.name AS book$periodical$name,
|
|
book$periodical.publish_month AS book$periodical$publish_month
|
|
FROM book book
|
|
LEFT JOIN periodical book$periodical ON book.publisher_id = book$periodical.publisher_id AND book.publish_month = book$periodical.publish_month |