[SOLVED] Query with multiple returns

[JaTochNietDan]

I'm trying to do a query here, it's hard to explain but I'll try my best. This is what I've come up with so far:

 

SELECT COUNT(*) FROM `territories` WHERE Owner = (SELECT Name FROM `gangs`)

 

So what I'm trying to do is get the amount of rows in the table `territories` for each gang name. "Owner" is the "Name" of the gang, which is why I'm trying to get the name in the second part of the query for owner.

 

I hope you somewhat understand. Any advice/help is appreciated. Thank you.

[kickstart]

Hi

 

Not 100% sure what you want, but think what you want could just be given by:-

 

SELECT Owner, COUNT(*) FROM territories GROUP BY OWNER.

 

All the best

 

Keith