4 Replies Latest reply: Apr 26, 2013 5:10 AM by Nitesh. RSS

    Sql Query

    1000501
      I have 3 tables Acquirer_tbl , Advice_tbl,Txn_entry_Tbl . I have to update the table Txn_entry_Tbl setting column Acquire_Id value( from Acquirer_tbl) coresponding to Advice_Id. Advice Id has to be generated from Advicetbl w.r.t oprt_Id and feed_dt . I have to get Acquire_Id value from Acquirer_tbl grouping Oprtr_Id and Acqr_Id.

      Please resolve this issue . I will be very Thankful..