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 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. 2226 > Fax: (876) - 923 - 5372 > > Cell: (876) - 3833566 > Email: [EMAIL PROTECTED] > [EMAIL PROTECTED] > > compashi <[EMAIL PROTECTED]> wrote: > > 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. > > Byeeeeeeeee Guys. > Have a good day. > > > > > > Sharing the knowledge on Axapta. > > > Yahoo! Groups SponsorADVERTISEMENT > > > --------------------------------- > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/Axapta-Knowledge-Village/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service. > > > > --------------------------------- > Do you Yahoo!? > Yahoo! Small Business - Try our new resources site! __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ ------------------------ Yahoo! Groups Sponsor --------------------~--> What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/