RE: SQL - select the record with the highest count value within afield

[AGlauser@xxxxxxxxxxxx]

Wouldn't the last join condition take care of that?

rpg400-l-bounces@xxxxxxxxxxxx wrote on 22/09/2006 04:22:27 PM:

> I haven't try it but I think it would result in:
> AAA      A12       D1          5
> BBB      B17       DC          5 (incorrect result, this record does not
> exist in original file)


#####################################################################################
Attention:
The above message and/or attachment(s) is private and confidential and is 
intended 
only for the people for which it is addressed. If you are not named in the 
address 
fields, ignore the contents and delete all the material. Thank you. Have a nice 
day.

For more information on email virus scanning, security and content
management, please contact administrator@xxxxxxxxxxxx
#####################################################################################