Home Forums SQL Server 7,2000 SQL Server Newbies Sum Three Columns From Two Tables RE: Sum Three Columns From Two Tables

  • June 5, 2014 at 6:04 am

    #1719165

    Koen Verbeeck (6/5/2014)

    nkweke (6/5/2014)

    Thanks again Koen, I am new here and still trying to grasp this sql stuff. Your suggestions are noted.

    I added the Group By and it pops up another error:

    Msg 4104, Level 16, State 1, Procedure GetTotalAmount, Line 10

    The multi-part identifier "shippingcart.shippingcost" could not be bound.

    Double check your alias. The error means SQL Server cannot find to which table the column shippingcost belongs.

    You were right I had shippingcart.shippingcost INSTEAD of shoppingcart.shippingcost.

    But the formular is giving me a wrong result. where shipping is null or zero. The result turns zero. Again thanks for your time.