I'm searching a table of people who own properties, and I want to
also include the total count of related properties, and the count of
related properties whose (status is 'Active' and approval is
'Active'). I've got:
select accounts.name, count(properties.property_id) as totalcount
from accounts, properties where
accounts.account_id=properties.account_id group by accounts.account_id;
Works fine. Now I just need to figure out how to add that second
count of property records meeting the two conditions. Anyone?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
