Is there a flag in the table tSalOrdr which indicates the last saved copy of a sales order. I am using SQL to query a sales order and I am finding duplicates which are related to every instance a sales order was saved. But the high Sales Order unique ID would be the latest copy. I am asking this because doing a select with a subselect in the WHERE is the only way I know the return many rows of the same high values in a column. If there was a flag that would make it much easier. Is the flag in another table?
I'm using Mircosoft query in Excel to do this which is not very friendly with the subquery I am adding in the "Where" of my statement. Thank you for your help.
-Nick