Mysql select query

#1

I have three tables books, author and publisher. I want a select query that lists all the book titles who publisher and author are from the same country. I try something like that but it didn’t work.

SELECT title
FROM books AS b, authors AS c, publishers AS p 
WHERE c.country=p.publisher_country
GROUP BY title;
#2

Any specific reason you’re using group by?

You might want to do a bit of a research on INNER JOIN.

#3

You can use INNER JOIN, please refer to the link below. I hope it will assist you

https://www.w3schools.com/sql/sql_ref_inner_join.asp

#4