SELECT
    "v"."Id" AS "ePOS_Variant_Id",
    "v"."ePOS Variant Name" AS "ePOS_Variant_Name",
    "vv"."CRM Record Id" AS "Verification_Record_Id",
    "vv"."Name" AS "Verification_Name",

    CASE
        WHEN "vv"."CRM Record Id" IS NULL THEN 'Create'
        WHEN "v"."Id" IS NULL THEN 'Delete'
        WHEN "v"."ePOS Variant Name" <> "vv"."Name" THEN 'Update'
    END AS "Action"
FROM  "ePOS Variants" AS "v"
FULL OUTER JOIN "ePOS Variant (Zoho Creator-Trees Verification Process)" AS "vv" 
    ON "v"."Id" = "vv"."CRM Record Id"
WHERE
    "vv"."CRM Record Id" IS NULL
    OR "v"."Id" IS NULL
    OR "v"."ePOS Variant Name" <> "vv"."Name"