Something like
Select file1.empno, file1.swipedate , file1.time1, file2.time2, file3.time3, file4.time4 from table1;
inner join table2 on table1.empno=table2.empno;
inner join table3 on table1.empno=table3.empno;
inner join table4 on table1.empno=table4.empno
If all the tables have an index tag on empno, the join should be superfast.
>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?