首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > Mysql >

in 与exists?该怎么解决

2012-07-31 
in 与exists????select article ,dealer,pricefrom shopwhere article0001or dealer IN (select dealer f

in 与exists????
select article ,dealer,price 
from shop  
where article=0001 
or dealer IN (select dealer from shop where article=0001);

装换成exists??怎么结果不对,谁能帮弄下。
select article ,dealer,price 
from shop  
where 
article=0001 
or
 exists (select dealer from shop where 
shop.dealer=shop.dealer and
 article=0001 );


[解决办法]

SQL code
SELECT article ,dealer,price  FROM shop   WHERE   article=0001  orEXISTS(SELECT dealer FROM shop WHERE  article=0001 ); 

热点排行