问个查询.... select * from tb1 where name='jack' and id not in(select number from tb2) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select id ,name,stfrom Awhere name = 'jack' and id not in (select number from B) select * from A表 where name='jack' and id not in (select number from B表) select * from A where not exists(select 1 from B where number=A.number) and name='jack' select * from A where not exists(select 1 from B where number=A.ID) and name='jack' 谢谢大家了 还要加个转换 select * from A where not exists(select 1 from B where number=cast(A.ID as char(10)) and name='jack' 怎么打开OPENDATASOURCE权限 请问有没有办法把一张表的数据自动转换成一条条insert语句? 一个简单多对多存储过程问题 如何赛筛选出多列内容相同的数据?? 求一sql语句,我想要这样的结果,请大侠帮助!急呀!!! SQL Server Configuration Manager 不能打开 为什么我的存储过程中的查询条件是中文时查不出相关信息 请教有经验的朋友!关于索引的问题! 关于链接服务器的事务问题(高分求教!!) C/S结构开发进销存软件。远程连接数据库时能否直接使用数据库服务器IP地址连接该SQL7.0服务器?该连接语句该如何写? 求教呀!!! 数据四舍五入的简单问题。
from A
where name = 'jack' and id not in (select number from B)
where name='jack'
and id not in (select number from B表)
*
from
A
where
not exists(select 1 from B where number=A.number)
and
name='jack'
*
from
A
where
not exists(select 1 from B where number=A.ID)
and
name='jack'
*
from
A
where
not exists(select 1 from B where number=cast(A.ID as char(10))
and
name='jack'