select
*
from
T2
order
by
(
select
sum
(Col2)
from
T1
where
Col1
=
t2.Col1)
desc
转载于:https://www.cnblogs.com/chenbg2001/archive/2009/05/18/1459696.html
转载于:https://www.cnblogs.com/chenbg2001/archive/2009/05/18/1459696.html