SELECT spp.Id
,spp.DELETE_KBN
FROM spp
LEFT JOIN spm
ON spp.Id = spm.Bussiness_Id
AND spp.DELETE_KBN = '0'
将DELETE_KBN !=0的也查出来了
SELECT spp.Id
,spp.DELETE_KBN
FROM spp
LEFT JOIN spm
ON spp.Id = spm.Bussiness_Id
where spp.DELETE_KBN = '0'
这样才能正确的查出数据,请问这二者在执行上的不同是什么?
提问题真爽