SQLITE3 selecting row matching multiple values from same column

Question

I use SQLITE3 for my DB,i have 3 table: Doc table (id,name,date),tag table (id,name,count) and the relation table (id_doc, id_tag) that connect doc and tag table (many to many relation). Now i'm stuck on a query: i want to select the id of document related to tag 1,2 and 3 but i can't figure out how to do this. anyone can help me?

Gordon Linoff · Accepted Answer · 2016-05-18 11:14:12Z

2

If I understand correctly, you can use aggregation and having. Something like this:

select id_doc
from relation r
where id_tag in (1, 2, 3)
group by id_doc
having count(*) = 3;

answered May 18, 2016 at 11:14

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLITE3 selecting row matching multiple values from same column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related