Re: SQL... MAX AND COUNT?

Try changeing it to HAVING LDQDAT = MAX(LDQDAT).

 
Jeff Young 
Sr. Programmer Analyst
Dynax Solutions, Inc.
A wholly owned subsidiary of enherent Corp.
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer 
V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions 
Implementer V5R3 


  
 





----- Original Message ----
From: Jay Vaughn <jayv@xxxxxxxxxxxxxx>
To: rpg400-l@xxxxxxxxxxxx
Sent: Tuesday, January 2, 2007 4:11:59 PM
Subject: SQL... MAX AND COUNT?


The precompiler doesn't like the "AND LDQDAT = MAX(LDQDAT)" in the following 
statement, but I ONLY need those latest dates considered in the count... How 
do I restructure this query to consider that?

C/EXEC SQL                                                         
C+ SELECT COUNT(LDSUBC) INTO :WKCOUNT FROM BANKHEDR INNER JOIN     
C+ LRDETAIL ON QHSTCD = LDSTCD AND QHAREA = LDAREA AND QHBANK =    
C+ LDBANK AND LDDGRP = QHHGRP AND LDCATC = :WKCATCD WHERE QHHGRP = 
C+ :WKGROUP AND QHRSTA = 'A' AND QHMAIN = :WKMAIN                  
C+ AND LDQDAT = MAX(LDQDAT)                                        
C/END-EXEC                                                         





Thanks,


Jay Vaughn
iSeries Senior Programmer/Analyst
RateWatch
jayv@xxxxxxxxxxxxxx
251-633-8929