SELECT book.BookName, autor.FirstName, autor.LastName FROM bookautor JOIN book ON book.BookID=bookautor.BookID JOIN autor on autor.AutorID=bookautor.AutorID;

SELECT rubric.RubricName FROM bookrubric JOIN rubric ON rubric.RubricID=bookrubric.RubricID;

SELECT book.BookName, autor.FirstName, autor.LastName, rubric.RubricName FROM bookautor,bookrubric JOIN book ON book.BookID=bookautor.BookID JOIN autor on autor.AutorID=bookautor.AutorID LEFT JOIN rubric ON rubric.RubricID=bookrubric.RubricID;

SELECT b.BookName,a.FirstName, a.LastName, r.RubricName
FROM BOOK b
INNER JOIN
BOOKAUTOR ba ON ba.BookID=b.BookID
INNER JOIN
AUTOR a ON a.AutorID=ba.AutorID
INNER JOIN
BOOKRUBRIC br ON br.BookID=b.BookID
INNER JOIN
RUBRIC r ON r.RubricID=br.RubricID

SELECT book.BookName, autor.FirstName, autor.LastName, rubric.RubricName
FROM book
LEFT JOIN bookautor ON (bookautor.BookID = book.BookID)
LEFT JOIN autor ON (autor.AutorID = bookautor.AutorID)
LEFT JOIN bookrubric ON (bookrubric.BookID = book.BookID)
LEFT JOIN rubric ON (rubric.RubricID = bookrubric.RubricID)