create proc ActivefFindItem
@ITEMID int,
@ACID int
as
DECLARE @PTYPE VARCHAR--商品范围
DECLARE @ITID varchar -- 关联的商品
SELECT @PTYPE=ac.PRODUCTTYPE, @ITID=pt.PRODUCTSID
from TB_PROMOTION_ACTIVE ac left join TB_PROMOTION_PRODUCT pr on ac.ID =pr.ACTIVEID
where ac.ID=@ACID
运行它就出错
@ITEMID int,
@ACID int
as
DECLARE @PTYPE VARCHAR--商品范围
DECLARE @ITID varchar -- 关联的商品
SELECT @PTYPE=ac.PRODUCTTYPE, @ITID=pt.PRODUCTSID
from TB_PROMOTION_ACTIVE ac left join TB_PROMOTION_PRODUCT pr on ac.ID =pr.ACTIVEID
where ac.ID=@ACID
运行它就出错
无法绑定由多个部分组成的标识符 "pt.PRODUCTSID"。 这是错误提示,
@ITEMID int,
@ACID int
as
DECLARE @PTYPE VARCHAR--商品范围
DECLARE @ITID varchar -- 关联的商品
SELECT @PTYPE=ac.PRODUCTTYPE, @ITID=pr.PRODUCTSID
from TB_PROMOTION_ACTIVE ac left join TB_PROMOTION_PRODUCT pr on ac.ID =pr.ACTIVEID
where ac.ID=@ACID
@ITEMID int,
@ACID int
as
DECLARE @PTYPE VARCHAR--商品范围
DECLARE @ITID varchar -- 关联的商品
SELECT @PTYPE=ac.PRODUCTTYPE, @ITID=pr.PRODUCTSID --这里为pr 不是pc
from TB_PROMOTION_ACTIVE ac left join TB_PROMOTION_PRODUCT pr on ac.ID =pr.ACTIVEID
where ac.ID=@ACID
pt-->pr