请问这样的SQL语句如何写?(内附例子) TRY:select b.*from Bread bwhere exists(select 1 from Cookies where Factory=b.Factory and FoodName!=b.FoodName) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 declare @Bread table(FoodName varchar(16),Factory varchar(16))insert into @Bread select '小安琪尔面包','桃李面包厂'insert into @Bread select '毛毛虫面包 ','桃李面包厂'insert into @Bread select '威化饼干' ,'桃李面包厂'insert into @Bread select '肉松卷' ,'永新面食'declare @Cookies table(FoodName varchar(16),Factory varchar(16))insert into @Cookies select '威化饼干' ,'桃李面包厂'insert into @Cookies select '儿童乐饼干','大荣食品厂'select b.*from @Bread bwhere exists(select 1 from @Cookies where Factory=b.Factory and FoodName!=b.FoodName)/*FoodName Factory ---------------- ---------------- 小安琪尔面包 桃李面包厂毛毛虫面包 桃李面包厂*/ select Bread.* from Bread,Cookies where bread.Factory=cookies.Factory and not bread.FoodName in (select foodname from cookies as c2)此语句未经过测试 关于数据库表的设计问题 麻烦啊,子查询返回的值不止一个是不允许 用select的时候怎样排除某个字段阿? 一个百思不得其解的问题,请各位大侠帮助 急!!在线等!高分诚心求助各位sql精英,一条sql汇总语句该如何写,有点难度,功力好的请进! sql查询语言的问题 请问可否取得某条记录的行号? SQL Server 2000 个人版真的不支持事务复制吗? 急需解决的SQL SERVER问题,不然全完了? MS SQL SERVER 插入数据隐性转换失败 下面的SQL语句输出的结果是什么? 问题没解决,再问关于数据的复制技术,请高手帮忙.
insert into @Bread select '小安琪尔面包','桃李面包厂'
insert into @Bread select '毛毛虫面包 ','桃李面包厂'
insert into @Bread select '威化饼干' ,'桃李面包厂'
insert into @Bread select '肉松卷' ,'永新面食'declare @Cookies table(FoodName varchar(16),Factory varchar(16))
insert into @Cookies select '威化饼干' ,'桃李面包厂'
insert into @Cookies select '儿童乐饼干','大荣食品厂'select
b.*
from
@Bread b
where
exists(select 1 from @Cookies where Factory=b.Factory and FoodName!=b.FoodName)/*
FoodName Factory
---------------- ----------------
小安琪尔面包 桃李面包厂
毛毛虫面包 桃李面包厂
*/