Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   How to frame a Query for this scenario ? (http://www.go4expert.com/forums/frame-query-scenario-t4271/)

aggiridharan 11May2007 16:19

How to frame a Query for this scenario ?
 
I have two tables T1 and T2. T1 contains transaction details with say date, oper_id, super_id, tran_no where oper_id and super_id are user id types used for posting/authorising the transactions.
T2 contains user_id and user_name. There could some users with more than one user_id as well ( ie the names are same with ids different)

Now, i want to find out all the transactions from T1 where oper_id and super_id correspond to same person (ie they have same user name in T2) . The assumption is all the users have distinct names.

Parimal 12May2007 12:01

Re: How to frame a Query for this scenario ?
 
hi
this could solve your problem

select t1.* from t1,t2 as x, t2 as y
where t1.op_id=x.uid
and t1.sp_id=y.uid
and x.uname=y.uname


All times are GMT +5.5. The time now is 02:13.