>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?

Evelyn,

This is your thread on the topic Time attendance table for time-log Thread #1399324 Message #1399324

To find your own messages click on yourself to open your profile and then there is a link to your messages there (I hope it's not a PUTM feature).