BennyLinton
Registered User.
- Local time
- Today, 08:48
- Joined
- Feb 21, 2014
- Messages
- 263
I need to modify the following query to count the number of people in each State in the US, any clues?:
SELECT dbo_certs.peopleId, dbo_People.FirstName AS [First], dbo_People.LastName AS [Last],
dbo_Status.StatusName AS Status, dbo_PeopleContactInfo.stateAbbrev AS State
FROM dbo_PeopleContactInfo INNER JOIN ((dbo_certs INNER JOIN dbo_People ON
dbo_certs.peopleId = dbo_People.peopleId) INNER JOIN dbo_Status ON dbo_certs.statusID = dbo_Status.StatusId)
ON dbo_PeopleContactInfo.peopleId = dbo_People.peopleId
WHERE (((dbo_certs.statusID)=2) AND ((dbo_PeopleContactInfo.Preferred)=True));
SELECT dbo_certs.peopleId, dbo_People.FirstName AS [First], dbo_People.LastName AS [Last],
dbo_Status.StatusName AS Status, dbo_PeopleContactInfo.stateAbbrev AS State
FROM dbo_PeopleContactInfo INNER JOIN ((dbo_certs INNER JOIN dbo_People ON
dbo_certs.peopleId = dbo_People.peopleId) INNER JOIN dbo_Status ON dbo_certs.statusID = dbo_Status.StatusId)
ON dbo_PeopleContactInfo.peopleId = dbo_People.peopleId
WHERE (((dbo_certs.statusID)=2) AND ((dbo_PeopleContactInfo.Preferred)=True));