Why would this fail?
The error message is "Unknown column 'b.id' in 'on clause'."
My goal is to bring in all the rows of the books and books_users tables matching with the WHERE clause, and then bringing in any other matching rows (but not required to be there) from the tables books_lists and lists.
SELECT DISTINCT b.*, bl.*
FROM books b, books_users bu
JOIN books_lists bl ON bl.books_id = b.id
JOIN lists l ON l.id = bl.lists_id AND l.isLive = 1
WHERE bu.users_id = '1'
AND bu.books_id = b.id
AND bu.relationship = '1'
GROUP BY b.title
ORDER BY bu.create_date