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]