select * from ( select 1 as ord,* from table1 union select 2 as ord,* from table2 *** ) order by ord
转楼上,这样肯定可以!不可以找我!
解决了 SELECT * FROM ( SELECT 2 AS ord,content_id FROM CITI_FORM_MEMBERS WHERE content_id = 'qj_form1_select6' UNION SELECT 1 AS ord,content_id FROM CITI_FORM_MEMBERS WHERE content_id LIKE 'qj%' ) ORDER BY ord SELECT 2 AS ord ,content_id FROM CITI_FORM_MEMBERS WHERE content_id = 'qj_form1_select6' UNION SELECT 1 AS ord, content_id FROM CITI_FORM_MEMBERS WHERE content_id LIKE 'qj%' ORDER BY ord都可以 不过不能用*
union
select 2,* from table2
....
(
select 1 as ord,* from table1
union
select 2 as ord,* from table2
***
)
order by ord
使用union关健字order by只能出现在最后位置
如:
select 1,* from table1
union
select 2,* from table2
order by filed
select * from
(
select 1 as ord,* from table1
union
select 2 as ord,* from table2
***
)
order by ord
转楼上,这样肯定可以!不可以找我!
SELECT * FROM
(
SELECT 2 AS ord,content_id FROM CITI_FORM_MEMBERS WHERE content_id = 'qj_form1_select6'
UNION
SELECT 1 AS ord,content_id FROM CITI_FORM_MEMBERS WHERE content_id LIKE 'qj%'
) ORDER BY ord
SELECT 2 AS ord ,content_id FROM CITI_FORM_MEMBERS WHERE content_id = 'qj_form1_select6'
UNION
SELECT 1 AS ord, content_id FROM CITI_FORM_MEMBERS WHERE content_id LIKE 'qj%'
ORDER BY ord都可以
不过不能用*