Subject SQL ERROR Code = -104 user name required
Author Criptyk Hayz
SQL ERROR Code = -104 user name required on this statement:

select s.pick, s.style, s.color, s.fgsize, sum(s.quantity)
from pick_summary s
where s.pick = '0187'
group by s.pick, s.style, s.color, s.fgsize
order by s.pick, s.style, s.color, s.sizesubscript

PICK_SUMMARY is a view:

CREATE VIEW PICK_SUMMARY(
PICK,
STYLE,
COLOR,
FGSIZE,
SIZESUBSCRIPT,
QUANTITY)
AS
select pick, style, color, fgsize, sizesubscript, sum(quantity)
from BOXHEADER
group by pick, style, color, fgsize, sizesubscript
union
select pick, STYLE, COLOR, FGSIZE, sizesubscript, sum(QUANTITY)
from RBPHANGING
group by pick, style, color, fgsize, sizesubscript
;

Any ideas?