This discussion is archived
4 Replies Latest reply: Apr 26, 2013 3:10 AM by Nitesh. RSS

Sql Query

1000501 Newbie
Currently Being Moderated
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..


  • Correct Answers - 10 points
  • Helpful Answers - 5 points