在一个查询中选择多对多表

试试这个查询

SELECt book.BookName, autor.FirstName, autor.LastName, rubric.RubricName FROM bookautorJOIN book ON book.BookID=bookautor.BookID JOIN autor on autor.AutorID=bookautor.AutorID left join bookrubric on book.BookID=bookrubric.BookIDLEFT JOIN rubric ON rubric.RubricID=bookrubric.RubricID;