sql1获取名称，sql2获取印象，我需要按印象对名称进行排序

我将添加与您上一个问题几乎相同的答案。您可以通过联接而不是单独的查询来完成所有操作；

SELECt t1.id as name, COUNT(DISTINCT t2.column1) ImpressionsFROM table1 t1LEFT JOIN table2 t2  ON t1.id=t2.column2WHERe t1.column1 = 1  AND LEFt(date,10) BETWEEN '2013-01-01' AND '2013-12-31'GROUP BY t1.idORDER BY Impressions DESC

要使用进行测试的SQLfiddle。