View Full Version : simple query problem


balzzy
02-24-2002, 04:38 AM
Hi there! I'm trying to get a small query working and i'm not sure how. I've built my data base for a minor hockey league. Within the database one coach can have many teams. Hence the relationship 1 to many for the coach table to the team table. I'm trying to build a query that will list all the coaches without teams. Any help on this one?

jwindon
02-24-2002, 05:58 AM
Run the unmatched query wizard on the Coach and Team table. That will give you what you want.