Dave I think his grasp of relational theory is weak, so I doubt that answer will mean anything to him. Let me have a go.
Your desire to use DISTINCT implies that there can be more than one row with a given value of GRP in it. Each one of these rows has its own copy of CMOD and DMOD. How do you expect SQL to work out which one of these rows to read for CMOD and DMOD when it contructs a return row for each distinct value of GRP? I suspect the problem has more to do with an incorrectly normalised data model than with SQL. _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
