6 Replies Latest reply: Nov 23, 2015 5:05 PM by Petter Skjolden RSS

    Join condition syntax error

    Satish Kurra

           Hi

       

      Help needed in below join condition. Throwing syntax error. Please help...

       

      LOAD *,

        month([OrderDate]) as OrderMonth,

        year([OrderDate])as OrderYear;

      SQL SELECT

        CustomerID,

        Sales_SalesOrderHeader.SalesOrderID as SalesOrderID,

        Sales_SalesOrderHeader.SalesPersonID     as SalesPersonID,

        TerritoryID,

        AccountNumber,

        OrderDate,

        CreditCardApprovalCode,

        SubTotal,

        TaxAmt,

        TotalDue,

        ProductID,

        OrderQty

          FROM Sales_SalesOrderDetail

          JOIN Sales_SalesOrderHeader

          ON Sales_SalesOrderDetail.SalesOrderID = Sales_SalesOrderHeader.SalesOrderID

          $(WHERE);