这个查询语句如何写?

[chenglf]

$New_Link = mysql_query("SELECT * FROM ads_link WHERE linkactive=1 ORDER BY amount DESC");
$Old_Link = mysql_query("SELECT * FROM ads_link WHERE linkactive=0 ORDER BY linktime DESC");

现在用这两条查询.查出来的结果分页处理不方便.可否实现一条语句就完成?这个查询语句如何写?

[chenglf]

或者如何将两次查询后的结果合并?

[blactte]

SELECT * FROM ads_link WHERE linkactive=1
union
SELECT * FROM ads_link WHERE linkactive=0

[chenglf]

关键是我的两次查询使用了不同的排序方式...这个如何解决?

[lingar]

可以用union SQL试试啊

[chenglf]

这样查询会出错啊..

[HawaiiLeo]

SELECT * FROM ads_link WHERE linkactive=1 ORDER BY amount DESC
UNION
SELECT * FROM ads_link WHERE linkactive=0 ORDER BY linktime DESC

这样不行吗？？

[ljl0206]

union 不能和 order by ,having同时使用的

[caiyunxia]

select * from(SELECT * FROM ads_link WHERE linkactive=1
union
SELECT * FROM ads_link WHERE linkactive=0)
order by .....