Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need help with 3 table query
Dan, thanks a lot to take time out for the reply! In the meantime, I found out a way. This one works probably only on SQL server though: SELECT temp1.trainer_id, tbl_slots.slot_id FROM tbl_slots CROSS JOIN temp1 LEFT OUTER JOIN tbl_trainer_bookings ON tbl_trainer_bookings.trainer_id =...- Ballonier
- Post #3
- Forum: -General database discussion
-
Need help with 3 table query
Hi all, I need some help with a query: 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...- Ballonier
- Thread
- Replies: 3
- Forum: -General database discussion
