query from tables with diff structure

[Guest]

Hi,
I have one employee table with employeeID as a primary key and availability
days as follows:
EmpID MonAM MonPM TueAM TuePM WedAM
1 0 1 o 1 0
2 1 0 1 0 1
....
and another table with time preferences as follows:
EmpID PrefNum StartTime
1 1 12:00:00AM
1 2 01:00:00AM
1 3 03:00:00AM
....
I'd need to get a one row per employee as for the first table.
Thanks

 

[Guest]

It looks as I've done it using crosstab query.

Thanks