Re: [Axapta-Knowledge-Village] Want to fetch distinct record from table

hi.. Try group by in ur query. Regards, Anitha On Mon, Aug 3, 2009 at 4:35 PM, Hemant Sonawane hemant.sonawan...@yahoo.com wrote: Hi, I want fetch distinct record from table. If any one have please let me know. Ex.. I have one table “*ProdTable*” in this table number of

[Axapta-Knowledge-Village] Want to fetch distinct record from table

Hi,    I want fetch distinct record from table. If any one have please let me know. Ex.. I have one table “ProdTable” in this table number of field is there, out of those one field name is “WrkCtrId”, so data in this table is as like this..     TmpAProd.WrkCtrId Line A Line B Line A Line