0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

declare @tag varchar(80) = '##Tag##'
declare @userid int = '##UserId##'

select id,
    tags from Posts p1
   where p1.Tags like '%' + @tag + '%'
   and p1.posttypeid = 1 
   except
   (select parentid,tags
       from posts p2
       where
       p2.posttypeid = 2
       and p2.owneruserid = @userid
    )

fork query

edited jan 26 20

created jun 24 19 anonymous