Re: getting sql error

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.

--
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.