RE: SQL... MAX AND COUNT?

My problem with your approach, Charles, is that it uses the 
highest date in
the whole LRDETAIL file.  Even if Jay wanted a count of all 
the records on
the highest date, then there still the question: should you limit your
SUBSELECT to only the records that match the original 
selection criteria?
In your case, MAX(LDQDAT) could return a date from a record 
that isn't even
in the select criteria, so the count would be zero!

Yep, but that's how I read his request.

Ah, the joy of SQL.

Now, Joe...lets not blame SQL for the confusion caused by the OP's
description of his requirements not being exact.

Given the same request but using RPG I/O I'd have given him the same
results.  Starting at EOF on LRDETAIL, reading backward though a logical
keyed on LDQDAT, chain to BANKHEDR to check the fields there, stopping
when LDQDAT changed.

Jay how about it?  What exactly are you trying to count?


Charles