[AccessD] Sub Query Assistance Requested

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue Nov 29 08:41:23 CST 2011


I have the following query that works correctly returning a result of 8

SELECT Count(A.PID) AS [Active Flowing Count]
FROM (SELECT DISTINCT A.PID
FROM [tbl Statuses During Prior Month] AS A
WHERE(A.Status In ("FL","FM","FH")));

I would also like to return the field EngArea from the table 
[tbl Statuses During Prior Month] also. Would that be possible and if so how? My attempts so far have failed.

Result should be something like this
Active Flowing Count 	EngArea
3				1
1				2
4				3 

Thanks.

Chester Kaup
Engineering Technician
Kinder Morgan CO2 Company, LLP
Office (432) 688-3797
FAX (432) 688-3799

 
No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.





More information about the AccessD mailing list