974      阿裏雲  技術社區[雲棲]

SQL存在一個表而不在另一個表中的數據

select a.id,a.oacode,a.custid,a.custname,a.xsz,a.salename,a.communicationtheme,a.communicationproperty,a.communicationtime,a.productmanager,'' creator,a.creator oaCreator,a.createdate,case when a.oastate='正常結束' then 3 else 0 end status from reception_flow a 
where  (1=1)
and (a.oastate='正常結束' or a.oastate='反饋中' or a.oastate='已反饋')
and (select count(1) as num from technology_support s where s.oacode=a.oacode)=0

最後更新：2017-04-03 05:40:00

  上一篇： DataGrid和DataGridComboBoxColumn數據綁定

  下一篇： poj 2498 StuPId