I know I posted this before but just can't find it now..

I have 4 tables:
Table1 fields:empno,swipedate,time1
Table2 fields:empno,swipedate,time2
Table3 fields:empno,swipedate,time3
Table4 fields:empno,swipedate,time4

I want to JOIN this tables into 1 table with empno,swipedate,time1,time2,time3,time4

I've tried other ways but it takes really long to combine these tables, I'm looking for a better way..


How can I do this?