RE: [PEAR] Dataobject : complex jointures

Hi. Thanks a lot for your -so quick- help. [cut] > > $D->selectAdd(); > $D->selectAdd('A1, A2, A3'); // fields from A table > > $B->joinAdd($E); > > $D->joinAdd($B); > $D->selectAs(); >>Likely the above call is killing the A selectAdds from above. Try removing the above line and see what you get. --> this solved the problem : A fields are now available. > > - SQL statement does not include A fields, nor E fields >> The A fields are missing likely due to the first selectAs call. The E fields aren't showing up because you didn't ask for them. Perhaps try a selectAs call for A, B, *and* E. --> Ok, I thought I had already selected E fields using $B->joinAdd($E) ? Since, E has no link with D, I canno't write $D->joinAdd($E)... David