Hi all,

I need some help with a query (SQL Server 7.0):
I have 3 tables:

tbl_trainer_bookings
.trainer_booking_id PK
.slot_id
.trainer_id

tbl_slots
.slot_id PK

temp1 (temporary table, trainer_id could be considered PK)
.trainer_id

I need a list of all combinations of
trainer_id and slot_id that are not in
tbl_trainer_bookings.

Hope this is a clear enough explanation,
and that somebody will be able to help me!

Regards,

Ballonier

That's easy:

SELECT trainer_id, slot_id
FROM temp1, tbl_slots
MINUS
SELECT trainer_id, slot_id
FROM tbl_trainer_bookings ;