Try the following
SELECT DISTINCT IDIDAT, idinvn, COUNT(DISTINCT idinvn)
FROM CA1665AFCV.SROISDPL T01
WHERE IDIDAT >= 20160101 AND IDORDT = 'FB'
GROUP BY IDIDAT,
IDINVN <-------- this is the change
with rollup
--
Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hoteltravelfundotcom
Sent: Wednesday, April 27, 2016 3:00 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: getting sql error
HI I am trying to sum distinct invoice num. idinvn, and a total by day.
where the date field is
ididat as yyyymmdd
Column IDINVN or expression in SELECT list not valid.
SELECT DISTINCT IDIDAT, idinvn, COUNT(DISTINCT idinvn)
FROM CA1665AFCV.SROISDPL T01
WHERE IDIDAT >= 20160101 AND IDORDT = 'FB'
GROUP BY IDIDAT with rollup
--
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.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
midrange.com
