问题菜鸟问题
大家好，我是新来的菜鸟，我学SQL才几天，有好多问题都不知道，以后请多多照顾。请问各位大虾下面我这个语句有什么问题？
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 (select shopid,saledate,billcount from cust_info
where shopid ='012010' and saledate between '20100601'and '20100610')
