高手帮我看下这个SQL语句错在哪

IF OBJECT_ID ('dbo.GETCKMX') IS NOT NULL
DROp FUNCTION dbo.GETCKMX
GO

CREATE FUNCTION GETCKMX(@ID INT)
RETURNS @P TABLE(WLID INT, ColorMCH VARCHAr (80),
SizeMCH VARCHAr (80), ColorID INT,
SizeID INT, SHL numeric(24,8),
BSHL numeric(24,8)
) AS
BEGIN
INSERT INTO @P(WLID,ColorMCH,SizeMCH, colorid,sizeid,SHL,BSHL)
SELECT WLID ,ColorMCH=B.NAME ,SizeMCH=C.NAME ,colorid,sizeid,SHL=sum(SHL),BSHL=sum(isnull(BSHL,0))
FROM STOCK A,ColorMXB B,SizeMXB C
WHERe A.WLID =@ID AND A.colorid =B.MXID AND A.sizeid =C.MXID
GROUP BY A.WLID ,A.colorid ,A.Sizeid
return
end
GO

那你在GROUP BY A.WLID ,A.colorid ,A.Sizeid后面加上‘,B.name,C.name’不就可以行了。

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息