5 Replies Latest reply: Sep 27, 2017 5:45 AM by Shraddha Gajare RSS

    Using column in other table in script

    zahid Rahim

      Dear Experts,

       

      I have two tables which i want to join and use one column in the second table like below:

       

      ORDERS:

      OrdId

      ItemId

      Quantity

      Amount

       

      PRICES:

      ItemId

      Price

       

      What i want

       

      ORDERS:

      OrdId

      ItemId

      Quantity*Price

      Amount

       

      PRICES:

      Outer Join(Orders)

      ItemId

      Price

       

      Regards,

       

      Zahid Rahim