select 的排序问题 高手们快来啊,谢谢了·······················
有一条sql
select * from table
where id in (select id from table1)
or id in (select id from table2)
就是id 要在两个表里选,我怎么样要让table1的id 排在 table2的前面
希望高手回答,谢谢了 !!!
[解决办法]
用 union 呢
[解决办法]
select * from (select *, NewOrder=1 from tb where id in (select id from table1) union all select *, NewOrder=2 from tb where id in (select id from table2) and id not in (select id from table1)) Torder by NewOrder