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