I guess next line in error message was like next: Column name 'A.SALESID' is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.
SO, while select sum(Field) from localSalesParmTable order by Field desc ... OR (may be) while select localSalesParmTable join localCustSalesLegalTxt group by salesId desc ... Regards --- In Axapta-Knowledge-Village@yahoogroups.com, "Daniel Zanni" <[EMAIL PROTECTED]> wrote: > > Hello, > > I have a SQL statement like this > > while select localSalesParmTable > join localCustSalesLegalTxt > group by salesId, salesLegalTxtId > where localSalesParmTable.SalesId == > localCustSalesLegalTxt.SalesId && > localSalesParmTable.ParmId == this.parmId() > > but I need the data usind order by with salesId exactly like this > > while select localSalesParmTable > order by salesId > join localCustSalesLegalTxt > group by salesId, salesLegalTxtId > where localSalesParmTable.SalesId == > localCustSalesLegalTxt.SalesId && > localSalesParmTable.ParmId == this.parmId() > > The Error happens and i get the following message > "Error:Cannot select a record in Sales order - Update table > (SalesParmTable). Sales order: , . > The SQL database has issued an error." > > Somebody knows what happens in this case, because for me the select > statement is correct > > Regards > > Daniel > > > [Non-text portions of this message have been removed] >