|
I am trying to do a query to update a flag field with an "x" if certain criteria are met.
The software I am using to find duplicate records give these duplicates a unique number called a "DupeGroup".
So I want to find:
if DupeGroup is the same, and last order history is null, than update flag field to "x".
Does someone know a quick way to be able to write this query as I apparently have lost my brain for the day...
Thanks
C-
|
