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