21,886
社区成员
发帖
与我相关
我的任务
分享
select top 1 a.bh, b.id from
(
select '20090330001' as bh
union
select '20090330002' as bh
union
select '20090330003' as bh
union
select '20090330004' as bh
union
select '20090330005' as bh
) a
left outer join a_tp b on a.bh = b.bh
where b.id is null
order by a.bh