Sorry my internet access is down so I am going to try and ask this question here instead of at a related site. I need to do a query like this: String sql="SELECT DISTINCT GRP,CMOD,DMOD FROM TABLE"; The problem is I only want distinct on the first column(GRP) but it returns all distinct combinations of the above three columns. Any sql pros out there? THANKS!! Graham
_______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user