Re: [Axapta-Knowledge-Village] How to perform self join in X++

Here is code CustTable CustTable1; CustTable CustTable2; select AccountNum from c1 join c2 where c1.AccountNum == c2.AccountNum ; --- Varden Morris <[EMAIL PROTECTED]> wrote: > Try declaring table buffers with different names as > follows: > > CustTable CustTable1; > CustTable CustTa

Re: [Axapta-Knowledge-Village] How to perform self join in X++

Try declaring table buffers with different names as follows:   CustTable   CustTable1; CustTable   CustTable2;   Use CustTable1 and CustTable2 in the query.    Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 22

[Axapta-Knowledge-Village] How to perform self join in X++

Hi Guys, Please tell me how to perform self join in X++ language. the same task can be done in SQL with the help of making aliases but i don't whether the same is possible in X++ or not. If somebody of you can jot down some code it will be higly appreciated. Bye Guys. Have a good day.