simple query problem

[balzzy]

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]

Run the unmatched query wizard on the Coach and Team table. That will give you what you want.