sql 查询不存在左表的数据

select * from zyz_mgr_wlcyiduifu a left join WLCInformation b ona.wlcId=b.WLCInvestorApplyID

where b.WLCInvestorApplyID is null

 

//如果左表数据带 单引号 及逗号

select * from zyz_mgr_wlcyiduifu a left join WLCInformation b on replace(replace(a.wlcId,'''',''),',','')=b.WLCInvestorApplyID

where b.WLCInvestorApplyID is null

posted @ 2015-04-02 19:07  秋香姑娘请你不要紧张  阅读(397)  评论(0)  编辑  收藏  举报