摘要： --一个连接查询，在Bn_scenes中去掉一些记录。select * from UFSystem..BN_Scenes where bSysVisible='1' and cBizSceneId not in (select cBizSceneId from BN_ScenesCustom where userid='likun5') order by iorder asc 使用existsselect * from UFSystem..BN_Scenes where bSysVisible='1' and not exists(select 阅读全文