Hi, DISTINCT is, uh, tricky. Start by checking this out<http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.axapta.programming&tid=929b2258-8a94-4ecb-ad77-f0849acb6fbd&cat=en_US_43057844-26db-48ec-8f54-3dff8e8cfd2f&lang=en&cr=US&sloc=&p=1> .
--m 2008/8/21 joelwu <[EMAIL PROTECTED]> > > Dear All: > > Anyone know how to do a select distinct in Dynamics AX, for exmple I have a > table like this > > F1 F2 F3 F4 F5 F6 F7 > A P-01 Ser TTA 0 0 0 > A P-01 Ser TTA 0 65 65 > A P-01 Ser TTA 35 0 -35 > A P-01 Spa EOI 0 0 0 > A P-01 Spa EOI 26.01 0 -26.01 > A P-02 Spa Cab 0 0 0 > A P-02 Spa Cab 596.25 0 -596.25 > A P Sub MLL 0 105 105 > A P Sub MLL 0 5000 5000 > > I want to get the unique field of F2, F3,F4 like the result bellow > > P-01 Ser TTA > P-01 Spa EOI > P-02 Spa Cab > P Sub MLL > > How can I do this in AX?? > > Joel > > >
