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]