sanfernandoChangeSignatory

CREATE TABLE xxfaas_signatory AS
SELECT *
FROM faas_signatory;

UPDATE faas_signatory
SET
recommender_objid = NULL,
recommender_name = NULL,
recommender_title = NULL,
recommender_dtsigned = NULL,
recommender_taskid = NULL,
approver_objid = NULL,
approver_name ='JEAN ROSE M. YEKE, CPA, REA, REB',
approver_title ='MUNICIPAL ASSESSOR'
WHERE objid IN (SELECT objid FROM faas_list WHERE state='CURRENT' AND ry='2018' AND txntype_objid='GR');