34,576
社区成员
发帖
与我相关
我的任务
分享
select News.* from NewsComments left join News on NewsComments.NewsID = NewsComments.NewsID
where NewsComments.PosterID = 2;
select * from news a
where a.NewsID in(select 1
from NewsComments b
and b.PosterID = 2)
select News.* from
(
select NewsID
from NewsComments
where PosterID =2
) NC
left join News on NC.NewsID = News.NewsID
select News.* from
(
select distinct NewsID
from NewsComments
where PosterID =2
) NC
left join News on NC.NewsID = News.NewsID