how to select multirecord and insert as a single record?

[sathyguy]

Friends,

I have two tables.

Table1:

tablename: timetable

Fields: empid
logdate
logtime
inout

here is the record of the above table.

EmployeeID LogDate LogTime InOut
1675 01/03/2006 06:39:16 0
1675 01/03/2006 20:07:48 1
2343 01/03/2006 08:30:16 0
2343 01/03/2006 18:07:48 1

Table2:

tablename: Empdetails

Fields: empid
empname

here is the record of the above table.

EmployeeID Empname
1675 abc
2343 dgfdfg

Now i want to combine the above two tables and insert into a new table.

the new tables field will be.

Empid Empname logdate timein timeout
1675 abc 01/03/2006 06:39:16 20:07:48
2343 dgfdfg 01/03/2006 08:30:16 18:07:48

how can i get the output like the third table from the top 2 tables?

Thanks
Sathyguy