mysql - SQL QUERY problem bookid -

mysql - SQL QUERY problem bookid -

how find books (show titles, authors , prices) on 'civil war' (i.e., title field contains 'civil war'), available in 'audio' format.

this schema * books (bookid, title, author, year) * customers (customerid, name, email) * purchases (customerid, bookid, year) * reviews (customerid, bookid, rating) * pricing (bookid, format, price)

i did did not work select b.title, b.author, p.price books b,pricing p inner bring together books on p.bookid b.title '%civil war%' , p.format '%audio%' grouping p.format, p.price

it looks on clause incomplete.

try this:

select b.title, b.author, p.price books b inner bring together pricing p on p.bookid = b.bookid b.title '%civil war%' , p.format '%audio%' grouping p.format, p.price

see = b.bookid @ end of inner join? that's issue.

mysql