日期:2014-05-17 浏览次数:20475 次
--SM_YCDXDETAIL 无2013070450记录
select * from JSJD_N_YONGCHANG where JSJD_N_YONGCHANG.guid='2013070450' -- 1条记录
select FSourceGUID from SM_YCDXDETAIL where FSourceGUID ='2013070450' --0条记录
select * from JSJD_N_YONGCHANG where
JSJD_N_YONGCHANG.guid not in (select FSourceGUID from SM_YCDXDETAIL)
and JSJD_N_YONGCHANG.guid='2013070450'
为什么查不出数据?
select * from JSJD_N_YONGCHANG where
not exists(select 1 from SM_YCDXDETAIL where JSJD_N_YONGCHANG.guid = SM_YCDXDETAIL.FSourceGUID)
and JSJD_N_YONGCHANG.guid='2013070450' -- 1条记录
??select?*?from?JSJD_N_YONGCHANG?where??
??JSJD_N_YONGCHANG.guid?not?in?(select?FSourceGUID?from?SM_YCDXDETAIL)?
??and?JSJD_N_YONGCHANG.guid<>'2013070450'