AW: [Axapta-Knowledge-Village] Re: Joining 3 tables with QueryBuildDataSource ?

2005-04-08 Thread Gahr, Andreas
nerstag, 7. April 2005 03:55 An: Axapta-Knowledge-Village@yahoogroups.com Betreff: [Axapta-Knowledge-Village] Re: Joining 3 tables with QueryBuildDataSource ? Hi Jesper, Thanks for your reply, but actually I already tried that and result is also wrong. If I debug it, the result query ->

[Axapta-Knowledge-Village] Re: Joining 3 tables with QueryBuildDataSource ?

2005-04-06 Thread Anton Tjiptadi
Hi Jesper, Thanks for your reply, but actually I already tried that and result is also wrong. If I debug it, the result query -> qbds = SELECT * FROM InventJournalTrans qbds1 = SELECT * FROM InventDim WHERE InventJournalTrans.InventDimId = InventDim.inventDimId AND ((InventLocationId = 01))