×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

inner join example for many-to-many relation

0
0
 
0
Language: SQL
Posted by: Ebraheem Bdarni
Added: Jul 20, 2020 9:01 PM
Views: 4505
Tags: inner join many-to-many mysql sql
  1. SELECT DISTINCT a.* FROM anbago.articles a
  2. INNER JOIN anbago.article_hashtag ah ON a.id = ah.article_id
  3. INNER JOIN anbago.hashtags h ON h.id = ah.hashtag_id
  4. WHERE h.name IN ("hashtag1","hashtag2","hashtag3");

Write a comment

To post comments, please log in or register.