lundi 2 février 2015

join 2 tables of first row of tabl1 to first row of table 2 [migrated]


I have 2 tables emptimein and emptimeoutOT. Both have the same fields.



table1
Emptimein
ID Date TimeIn

table2
ID Date TimeOutOT


I want to join both tables to combine the first row of the emptimein table and emptimeout table


I want a result like this



ID Timein TimeOutOT




Aucun commentaire:

Enregistrer un commentaire