Dear All UT Group members
hi to all after such a long time.
i would like to know how to pass one query result on 2nd query as a Paramtetr.
for example hear is the my Query.

1st Query :-
Select * from Employee_v as Emp
Note:- Bring all information from Employee Table

2nd Query :-
select TOCID from sab.dbo.propval AS B
where B.prop_id = 41 and str_val = emp.empid
Note:- Table call Propval query bring data only related to respected Employee

3rd Steps:-

Update sab.dbo.propval set str_val = emp.Title
WHERE TOCID = b.tocid AND prop_id=42
update the Propval table row as per the requierment.

so need a help is the my qery syntex is correct or requier to update.

Best Regards
Mazahir