MERGE INTO inventory USING updated_inventory ON inventory.product_id = updated_inventory.product_id WHEN MATCHED THEN UPDATE SET inventory.quantity = updated_inventory.quantity, inventory.price = updated_inventory.price WHEN NOT MATCHED BY SOURCE THEN INSERT (product_id, product_name, quantity, price, is_active) VALUES (updated_inventory.product_id, updated_inventory.product_name, updated_inventory.quantity, updated_inventory.price, true) WHEN NOT MATCHED BY TARGET THEN UPDATE SET is_active = false;

MERGE INTO inventory USING supplier_updates ON inventory.product_id = updated_inventory.product_id WHEN MATCHED THEN UPDATE SET inventory.quantity = updated_inventory.quantity, inventory.price = updated_inventory.price WHEN NOT MATCHED BY SOURCE THEN INSERT (product_id, product_name, quantity, price) VALUES (updated_inventory.product_id, updated_inventory.product_name, updated_inventory.quantity, updated_inventory.price) WHEN NOT MATCHED THEN UPDATE SET is_active = false;

MERGE INTO inventory USING updated_inventory ON inventory.product_id = updated_inventory.product_id WHEN MATCHED THEN UPDATE SET updated_inventory.quantity = inventory.quantity, updated_inventory.price = inventory.price WHEN NOT MATCHED THEN INSERT (product_id, product_name, quantity, price, is_active) VALUES (updated_inventory.product_id, updated_inventory.product_name, updated_inventory.quantity, updated_inventory.price, false) WHEN NOT MATCHED BY SOURCE THEN UPDATE SET is_active = true;

MERGE INTO updated_inventory USING inventory ON updated_inventory.product_id = inventory.product_id WHEN MATCHED THEN UPDATE SET updated_inventory.quantity = inventory.quantity, updated_inventory.price = inventory.price WHEN NOT MATCHED THEN INSERT (product_id, product_name, quantity, price, is_active) VALUES (inventory.product_id, inventory.product_name, inventory.quantity, inventory.price, true) WHEN NOT MATCHED BY SOURCE THEN UPDATE SET is_active = false;