[Axapta-Knowledge-Village] Error in Sql Statement

[Daniel Zanni]

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]