Mysql select query

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 
GROUP BY title;

Any specific reason you’re using group by?

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

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