mysql union all 使用
select * from (select stone_id,stpm from tbl_material_stone where stone_id<=10 order by stone_id asc) as t1 union all select * from (select stone_id,stpm from tbl_material_stone where stone_id>10 and stone_id<21 order by stone_id desc) as t2
lunzi   2010-07-30 00:03:58 评论:0   阅读:2984   引用:0

发表评论>>

署名发表(评论可管理,不必输入下面的姓名)

姓名:

主题:

内容: 最少15个,最长1000个字符

验证码: (如不清楚,请刷新)

Copyright@2004-2010 powered by YuLog