Kaup, Chester
Chester_Kaup at kindermorgan.com
Thu Jul 30 15:22:13 CDT 2009
Any ideas on how to speed up this query other than get a better computer? Table Configmaster is a linked access table on a network drive. Other two tables are native tables on my local C drive. SELECT [tbl Injection Volume Total around a Pattern].Pattern, [tbl Injected Volume Total around Producer].ForecastDate, [tbl Injected Volume Total around Producer].ProducerWellname, [tbl Injected Volume Total around Producer].SumOfRBI AS Inner_Injection_Total, [tbl Injection Volume Total around a Pattern].RBI AS Outer_Injection_Total FROM ([tbl Injected Volume Total around Producer] INNER JOIN ConfigMaster ON [tbl Injected Volume Total around Producer].ProducerWellname = ConfigMaster.ChildPID) INNER JOIN [tbl Injection Volume Total around a Pattern] ON (ConfigMaster.PID = [tbl Injection Volume Total around a Pattern].Pattern) AND ([tbl Injected Volume Total around Producer].ForecastDate = [tbl Injection Volume Total around a Pattern].ForecastDate) ORDER BY [tbl Injection Volume Total around a Pattern].Pattern, [tbl Injected Volume Total around Producer].ForecastDate, [tbl Injected Volume Total around Producer].ProducerWellname; 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.