0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Tridion developers and administrators

select 
    p.Id, 
    p.tags 
from 
    posts p
inner join (
    select 
        PostId 
    from 
        posttags 
    where 
        tagid in (4, 2) 
    group by 
        PostId 
    having 
        count(PostId) > 1
) sep on p.Id = sep.PostId;

fork query

created nov 24 jon.doe46369