have 2 tables X and Y in DB2 V8 db

Table X
-----------------------------------
COL S COL V COL S
--------- ------------ ---------
S1 A TT
S1 B TT
S1 C TT
S2 F TT
S3 D TT
S3 Z TT

Table Y
-----------------------------------
COL V COL N
----------- --------------
A 30
B 20
C 60
F 10
D 80
Z 40

Result needs to be 1 row per distinct COL S values and the one with the highest value in COL N . So in above case :
S1 C 60
S2 F 10
S3 D 80


Thanks

Found it .
select X.S,MAX(Y.N) from X,Y
where X.V = Y.V
group by X.S;

with t1 (s,v,n) as
(select x.cols,x.colv,t.coln from x inner join y on (x.colv = y.colv)),
t2 (s,n) as
(select s,max(n) from t1 group by s)
select * from t1 where (s,n) in (select * from t2)

Andy