Hi,

I need to make a query some joins but I met some problem.
I have 2 tables connected many to one relationship.

Tables are Systems (SystemID, SystemName) and Servers (ServerID, ServerName, SystemID, RegionID) (one system can have many servers)
I need to use Servers table to make join with Region table bacause I want to count Systems in each region.

I tried to do this with joins but it doesn't work because I always get servers count.

Any ideas how it can be done?