ThreadID ParentID ThreadAuthor
05 05 wgh
06 05 有痔青年
07 05 abc
08 05 abc
09 09 zxw
10 09 ll
11 09 abc这是bbs的贴子表结构 ThreadID与ParentID相等的为楼主发的贴,不相等的为跟贴,
现在我想查询用户abc跟贴的所有楼主贴 ,也就是ThreadID为05,09的贴,用SQl语句如何写
05 05 wgh
06 05 有痔青年
07 05 abc
08 05 abc
09 09 zxw
10 09 ll
11 09 abc这是bbs的贴子表结构 ThreadID与ParentID相等的为楼主发的贴,不相等的为跟贴,
现在我想查询用户abc跟贴的所有楼主贴 ,也就是ThreadID为05,09的贴,用SQl语句如何写
select distinct parentid from table where threadauthor = 'abc' and treadid=parentid
) y on x.ThreadID=y.parentid
select distinct parentid from table where threadauthor = 'abc' and treadid<>parentid
) y on x.ThreadID=y.parentid
能具体解释一下x,y吗?谢了,
SELECT ParentID FROM TBL WHERE ThreadAuthor='aaa')
SELECT ParentID FROM TBL WHERE ThreadAuthor='aaa')