One last time before I give it a rest, I would like to create a query to update two dates (MemberThruDate & LastRenewalDate) in family member records (MemberMaster) using a new View (View_PriMemDates) containing the source data. The foreign key PrimaryID in the MemberMaster is used to select the View record. I have made an SQL Command script that executes and performs correctly, however I’m trying for this to be run from the Query menu by someone not confident to run an SQL command script. I’ve tried various versions by starting with SELECT with no success. Thanks in advance for any insights. The working script is:
MERGE INTO "MemberMaster" USING "View_PriMemDates" ON "MemberMaster"."PrimaryID" "View_PriMemDates"."MemberID" AND "MemberMaster"."MemberType" = 'F' WHEN MATCHED THEN UPDATE SET "MemberMaster"."MemberThruDate" = "View_PriMemDates"."MemberThruDate", "MemberMaster"."LastRenewalDate" = "View_PriMemDates"."LastRenewalDate"