I want to update the Status of the NASE_Records table if the MemberNum in that table does not Exist in the SAS_Download table.

I don't think my sub query WHERE clause is right but I can't really test it cause this is live data and I don't want to screw up my table.




Code:
UPDATE    NASE_Records
SET              Status = 'I'
WHERE     (NOT EXISTS
                          (SELECT     *
                            FROM          SAS_Download
                            WHERE      (SAS_Download.MemberNum = NASE_Records.MemberNum)))

Any help would be great, thanks!