RE: SQL View question

Wouldn't you want something like this:
select shp,sea,sty,clr,fab,mod,msz, sum(qty) as ResultColumn
from INVPHY
where rid = 81251501 and shp=50875 and sty= 'J4LW2700'
group by shp,sea,sty,clr,fab,mod,msz
order by shp,sea,sty,clr,fab,mod,msz

** - Replacing the sum() with whatever function you want, or maybe use DISTINCT and remove the GROUP BY (depending on your goal).




-----Original Message-----
From: Art Tostaine, Jr. [mailto:atostaine@xxxxxxxxx]
Sent: Thursday, August 30, 2018 12:22 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: SQL View question

RID is like a record key so the group by doesn't work.
I took the group by out of the view and added RID.

Here is view
create view InvPhy (rid,shp,sea,sty,clr,fab,mod,msz,qty) as (SELECT ls.rid,ls.shp,ls.sea,ls.sty,ls.clr,ls.fab,ls.mod,ls.msz,ls.qty
FROM invdta.locsku00 as ls);

Here is my select says RID or expression in select list not valid

select * from INVPHY
where rid = 81251501 and shp=50875 and sty= 'J4LW2700'
group by shp,sea,sty,clr,fab,mod,msz
order by shp,sea,sty,clr,fab,mod,msz

[SQL0122] Column RID or expression in SELECT list not valid. [SQL State=42803, DB Errorcode=-122]