IN is OR, I want the AND logic. Select posts which has tag 1, 2 and 3 ( tag ids 
)


Thanks,

Arup Rakshit
a...@zeit.io



> On 12-Sep-2018, at 8:58 PM, Ron <ronljohnso...@gmail.com> wrote:
> 
> Maybe this:
> select p.id, p.name
> from posts p,
>      posts_tags pt,
>      tags t
> where t.id in (1, 2, 3)
>   and t.id = pt.tag_id
>   and pt.post_id = p.id;
> 
> 
> On 09/12/2018 10:23 AM, Arup Rakshit wrote:
>> I have a table posts(id, name), posts_tags(post_id, tag_id) and tags (id, 
>> name) ... I want to get all posts which has tag id 1, 2 and 3 for example. 
>> How should I do this? I tried ALL, but it didn’t work.
>> 
>> Those tag ids comes from UI by users, so I am looking for generic approach.
>> 
>> 
>> Thanks,
>> 
>> Arup Rakshit
>> a...@zeit.io <mailto:a...@zeit.io>
>> 
>> 
>> 
> 
> -- 
> Angular momentum makes the world go 'round.

Reply via email to