I am looking for following query in Oracle
I have a table Tbl1
I need fetch all the data from Tbl1
But where Tbl1.Fld1 = Tbl2.Name return Tbl2.UID as Tbl2UID
where Tbl1.Fld2 = Tbl3.Name return Tbl3.UID as Tbl3UID
.. a fewmore till Tbl1.Fld10 = Tbl10.Name return Tbl10.UID as Tbl10UID
I may be able to write it with Case statement . But is there a more compact way of doing it?