dimanche 26 juillet 2015

Join 3 tables in Sql Server

I have 3 tables clalled tbl_monday, tbl_tuesday, tbl_Wednesday and consist of data as follows.

tbl_Monday

id    empid   Plan
---------------------
1     6       Mon_27
2     6       Mon_27
3     6       Mon_27

tbl_Tuesday

id    empid   Plan
--------------------
1     6       Tue_28
2     6       Tue_28
3     6       Tue_28     

tbl_Wenesday

id  empid     Plan
------------------
1     6       Wed_29
2     6       Wed_29
3     6       Wed_29

Is there any eazy way to get result like this ?

empid    Plan
----------------------
6       Mon_27
6       Tue_28
6       Wed_29

Aucun commentaire:

Enregistrer un commentaire