Re: getting sql error

[Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>]

yes thanks,


On Wed, Apr 27, 2016 at 3:02 PM, Alan Shore <ashore@xxxxxxxx> wrote:

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