select * from table1 where 1=1 order by 日期 desc
union
select * from table2 where 1=1 order by 日期 desc提示union 附近有语法错误但把两个order by 去掉就 可以了不知大家遇到过这个问题没有?
union
select * from table2 where 1=1 order by 日期 desc提示union 附近有语法错误但把两个order by 去掉就 可以了不知大家遇到过这个问题没有?
select * from table1 where 1=1
union
select * from table2 where 1=1)a
order by 日期 desc
union
select * from table2 where 1=1 order by 日期 desc第一个去掉就可以了不过是等于:
(select * from table1 where 1=1 --order by 日期 desc
union
select * from table2 where 1=1 )order by 日期 desc