34,593
社区成员
发帖
与我相关
我的任务
分享
select username,date,shangban,xiaban
from A left join B on A.userid=B.userid
where A.userid not in(
select userid from B where date='XXXX-XX-02')
declare @date varchar(10)
set @date=' 2012-11-1'
SELECT a.userName,
b.date,
b.shangban
FROM a
left join b on a.userid = b.userid
WHERE convert(varchar(10),b.date)= @date
and b.shangban is null