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,T2.field2 from
T1) as P1 left join (Select sum(T2.field4) from Table2) as P2 on P1.field1 =
P2.field1
thx,
Guillermo
