日期:2014-05-16 浏览次数:20832 次
select * from label1 where b > 1000 or c > 1000 or d > 1000 or e > 1000 UNION ALL select * from label2 where b > 1000 or c > 1000 or d > 1000 or e > 1000 UNION ALL select * from label2 where b > 1000 or c > 1000 or d > 1000 or e > 1000
------解决方案--------------------
SELECT * FROM lable1 WHERE a>1000 or b>1000 OR c>1000 OR d>1000 OR e>1000 OR f>1000;
------解决方案--------------------
详细说明,是同一服务器中?
------解决方案--------------------
select * from label1
where b>1000 or c>1000 or d>1000 or e>1000 or f>1000
------解决方案--------------------
SELECT * FROM lable1 WHERE b>1000 OR c>1000 OR d>1000 OR e>1000;