You have to set the fetchMode on the child QueryBuildDataSource objects to QueryFetchMode::One2One - the query will be OK after that
--- In [email protected], "axaeffect" <[EMAIL PROTECTED]> wrote: > > Hi all, > > how to join 3 tables in querybuilder? > > for example I want to join InventDim Table with inventBatch and > WMSLocation > > In my logic should be like this > 1. first Query is InventDim > 2. join InventDim to InventBatch > 3. join inventDim again to WMSLocation > > is that correct? bcoz when I check the query, after step 2, the query > is correct, inventdim join to inventbatch, but after step 3, seem > inventdim query loose all the join. > > I mean, can in Axapta, 2 different table join to 1 main table ? > > > thanks in advance, > Ton >
