SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%agency_%' group by TABLE_SCHEMA SELECT Invoice_ID FROM #Request.prefix_db_agency#.Invoices i WHERE i.Deleted <> 1 Group by i.Invoice_Id UPDATE #Request.prefix_db_agency#.Payments AS p JOIN #Request.prefix_db_agency#.Invoices AS i ON i.Invoice_ID = p.Invoice_ID JOIN ( SELECT MAX(PaymentDate) AS LatestPaymentDate FROM #Request.prefix_db_agency#.Payments WHERE Invoice_ID = #Invoice_ID# AND Deleted <> 1 ) AS latest ON p.PaymentDate = latest.LatestPaymentDate SET p.Pay_Seq_Amount = i.Seq_Amount, p.Pay_outlier = i.outlier, p.Pay_Seq_code = i.Seq_code WHERE p.Deleted <> 1 AND i.Deleted <> 1 AND p.Invoice_ID = #Invoice_ID# AND (IFNULL(p.Payment_Lock,0) <> 1)