问题菜鸟问题

select SHOPID,SDATE,lcate,xse
From storesale_nrate
where (shopid ='012010'  and sdate between '20100601'and '20100610')
   or (shopid='012010' and sdate between '20100501'and '20100510')
   and EXISTS(select shopid,saledate,billcount from cust_info
        where shopid ='012010' and saledate between '20100601'and '20100610')
一.你提问要把错误提示最好也贴上来,毕竟别人没法在你的数据环境下调试
二.你的错误应该是少了"EXISTS"
三.你逻辑上应该还有个错误 你的"OR"和"AND"操作没有用括号分隔,这样的查询返回的结果肯定不是你想要的
select SHOPID,SDATE,lcate,xse
From storesale_nrate
where ((shopid ='012010'  and sdate between '20100601'and '20100610')
   or (shopid='012010' and sdate between '20100501'and '20100510'))
   and EXISTS(select shopid,saledate,billcount from cust_info
        where shopid ='012010' and saledate between '20100601'and '20100610')