hallo mas chan, coba pake sintak ini
SELECT col.col1, Max(col.col2) AS col2, col.col3
FROM col
GROUP BY col.col1, col.col3;
salam
Lilis Suryani ArjaMaya
____________________________________________________________________________________Shape
Yahoo! in your own image. Join our Network Research Panel today!
http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
