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