Join columns from multiple tables Join columns from multiple tables database database

Join columns from multiple tables


Tested with your data on an old version (4.24) of MySql and this should be your query

SELECT r.Name, b.Title, br.RatingFROM Reviewer r JOIN BookReview br on br.ReviewerID = r.ReviewerID     JOIN Book b ON b.ISBN = br.ISBNWHERE r.EmployedBy IS NULL OR r.EmployedBy = ''

this is the result

'Leone', 'How to Keep your Cellular Bill Down', 7
'Leone', 'How to Keep your Cable Bill Down', 7
'Leone', 'From Deep in the Heart of Texas to IT', 6