I’m trying to retrieve articles that have the same category.
I have 3 tables;
- Articles (the article themselves)
- Categories_per_articles (contains the id of articles and the categories associated with it)
- Categories ( currently has 3 categories)
My SQL is trying say this; Can you please show me all the articles that are placed in the same category.
This is is what I’ve wrote;
SELECT * FROM blog, categories_per_article INNER JOIN category WHERE category.cat_id AND categories_per_article.cat_id = 1
And it brings me backeverything…
Any help will be ace!