sql - 'WHERE'附近的存储过程SYNTAX错误

Question

是否有人知道导致错误的原因:“关键字“WHERE”附近的语法不正确”

CREATE PROC proc_ProductInf
    @SalesOrderID int,
    @SalesOrderOut int OUTPUT,
    @OrderDate datetime OUTPUT,
    @ShipDate int OUTPUT,
    @CityState varchar(100) OUTPUT
AS
BEGIN
    SET NOCOUNT ON;

SET @SalesOrderOut = @SalesOrderID

SET @OrderDate = (SELECT OrderDate FROM sALES.SalesOrderHeader )

SET @CityState = (
    SELECT          City, State
    FROM            Sales.SalesOrderHeader s     
    LEFT OUTER JOIN Person.Address a
    ON              s.ShipToAddressID = a.AddressID
    LEFT OUTER JOIN Person.StateProvince st
    WHERE           SalesOrderID = @SalesOrderID
    )

END

DECLARE @OrderNum int, @Date datetime, @Qty int
EXEC proc_ProductInf 63936, @SalesHeaderOut=@OrderNum OUTPUT,
    @OrderDate=@Date OUTPUT,
    @NumItems=@Qty OUTPUT

Answer 1

您没有在上指定 ON来将Person.Address加入到Person.StateProvince。

SET @CityState = (
 SELECT City, State
 FROM Sales.SalesOrderHeader s 
 LEFT OUTER JOIN Person.Address a
 ON s.ShipToAddressID = a.AddressID
 LEFT OUTER JOIN Person.StateProvince st
 ON a.AddressStateProvinceID = st.StateProvinceID
 WHERE SalesOrderID = @SalesOrderID
 )

END