I want to insert the data coming from the below query into the JOIN.
select distinct a.CUser_id,b.User_Id, b.first_name + ' ' + b.last_name NAME
from inward_doc_tracking_trl a, user_mst b
where a.CUser_id = b.mkey
How to achieve it ?
I am using SQL server 2005
Aucun commentaire:
Enregistrer un commentaire