Subject | SQL ERROR Code = -104 user name required |
---|---|
Author | Criptyk Hayz |
Post date | 2003-11-10T17:51:04Z |
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?
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?