mardi 17 mai 2016

Need to insert the join query data into temp table

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