ML Azure

c1,c2,c3
"a",1,2.3
"b",2,3.4
"c",3,4.5

c1,c4
"x",1
"y",2
"a",3
"b",4
"c",5
__________________

select t1.c1,c2,c4
from t1 inner join t2 on t1.c1=t2.c1
order by c3 desc