sql语句优化

Question

[code="java"]
select * from dbo.tbGoodsInfo where (id in (select distinct isnull(goodsId,'') from dbo.tbGoodsBindArea )
or id in(select distinct isnull(goodsId,'') from dbo.tbGoodsBindBar where barUserId='cdcs'))
and auditStatus=0 and bupd!=-1 and goodsType=1
union
select * from dbo.tbGoodsInfo where (id not in (select distinct isnull(goodsId,'') from dbo.tbGoodsBindArea )
and id not in(select distinct isnull(goodsId,'') from dbo.tbGoodsBindBar where barUserId='cdcs'))
and auditStatus=0 and bupd!=-1 and goodsType=1[/code]

如题求解

Answer 1

不好意思，没有环境，sql server用得不多，难免语法错误 呵呵，说下思路：
你检索的数据实际上就是满足那3个条件的数据，只是这些数据的顺序不同，把ID存在表tbGoodsBindArea和表tbGoodsBindBar的数据放到前面，其他数据放到后面。

所以，让表tbGoodsInfo和上面sql的表M进行left join，关联到的数据排到前面，具体你再改改~~~：）