No, select distinct is not implemented in Ax. You can achieve the same with:
Select <Field1>, <Field2> from <Table> Group by <Field1>, <Field2> Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager ________________________________ Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von syed baber Gesendet: Montag, 2. Juni 2008 18:05 An: development-axapta@yahoogroups.com Betreff: [development-axapta] How to select distinct records from a column Hi All, I want to select distinct records from a column. Plz let me know is there any keyword available in Axapta for selecting distinct records like there in Oracle. Regards Syed Baber. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]