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
great
Separate names with a comma.