Hello compashi1,

понедельник, 14 марта 2005 г., you wrote:

c> Guys I am looking to do self-joins in X++.
c> The same can be done in SQL quite easily with the help of making
c> aliases and then joining these two aliases of same table.  i am not
c> sure whether the same can be done in X++ or not.
c> please do support with the help of little bit code.

TableName tab1, tab2;

select tab1 join tab2 where tab2.field1==tab1.field2;


--
Best regards,
Max                           

http://belugin.newmail.ru
ICQ:9406811





Yahoo! Groups Sponsor
ADVERTISEMENT
click here


Yahoo! Groups Links

Reply via email to