Re: easy - optimizing query

On 6/21/07, Guillermo <[EMAIL PROTECTED]> wrote: Hello, I have a query that i could do in 2 diferent ways...i want to know wich one is recomended: * Select T1.field1,T1.field2, (select sum(T2.field4) from Table2 T2 where T2.field1 = T1.field1) from Table1 T1 or * Select P1.fie

easy - optimizing query

Hello, I have a query that i could do in 2 diferent ways...i want to know wich one is recomended: * Select T1.field1,T1.field2, (select sum(T2.field4) from Table2 T2 where T2.field1 = T1.field1) from Table1 T1 or * Select P1.field1,P1.field2,P2.field2 from (Select T1.field1,