Why am I Getting a Group By Error?

dvdaddict32 · #1 (**permalink**) 10-26-11, 13:04

Hey guys,

I can't figure out why my query is giving me errors. I'm trying to find people who are age 62 or older.

I'm getting use of reserve word GROUP is not valid. The query works fine if I take out the line where I'm searching for age. Here is my query:

Code:


SELECT    E.CTY_ID_NM,
          count(*) as COUNT
FROM     DSNP.PR01_T_MBR_SYS A, 
         DSNP.PR01_T_MBR B, 
         DSNP.PR01_T_MBR_CITY C, 
         DSNP.PR01_T_ZIP D, 
         DSNP.PR01_T_CTY E 
WHERE    A.MBR_SSN_NBR=B.MBR_SSN_NBR 
AND      A.MBR_SSN_NBR=C.MBR_SSN_NBR 
AND      C.POST_ZIP_CD=D.POST_ZIP_CD 
AND      D.CTY_ID_CD=E.CTY_ID_CD 
AND      A.MBR_STAT_CD = '1' 
and ((YEAR(CURRENT DATE) - YEAR(b.mbr_BIRTH_DT) >= 62)


group by E.CTY_ID_NM

Any ideas?

tonkuma · #2 (**permalink**) 10-26-11, 13:15

Please read and post with enough information to get quick, apt and meaningful responses:
Must Read before posting

Quote:

...

Please follow these guidelines to get quick, apt and meaningful responses :

1) Every question posted must include your DB2 Version, fixpack and Edition + your Operating System(including version info) + info on any third party software you use.
You can get his info using the following commands
db2level -> to get db2 version and fixpack level
db2licm -l -> to get the db2 type (WSE, ESE, etc)

2) If you question is regaring an error, make sure you post the error code, corresponding message and the command/sql which caused the error.

...