RE: SQL selects

You need to group by the dbmdc# field.

-----Original Message-----
From: Dan Rasch [mailto:drasch@xxxxxxxxxxxx] 
Sent: Tuesday, November 11, 2003 3:08 PM
To: Midrange Systems Technical Discussion
Subject: SQL selects



We have a user trying to use SQL to format three fields for a vendor. this
works, although it is not as complete as desired:

SELECT dbmdc# as check,                                           
       decimal(dbmddt*10000.0000001-10299997997,11,0) FROM dbmtckp
       WHERE dbmcpy ='F' and dbmdc# between 26969 and 26999 
       and dbmddt > 1030000

SELECT statement run complete.                                    

this fails:

SELECT dbmdc# as check,                                           
       decimal(sum(dbmamt)*100,12,0),                             
       decimal(dbmddt*10000.0000001-10299997997,11,0) FROM dbmtckp
       WHERE dbmcpy ='F' and dbmdc# between 26969 and 26999 
       and dbmddt > 1030000

Column DBMDC# or expression in SELECT list not valid.             

Adding the sum function seems to cause a problem,
any clues?

TIA, 

Dan Rasch - because if the human species concentrated on the really 
important things in life, there would be a shortage of fishing poles! IBM
Certified twice....... but still a couple PTFs away from Nirvana.

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.