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.