UPDATE 
meta.toShow TS INNER JOIN ( SELECT PNR FROM PNR_Trigger.PNR_Ticket_Details WHERE Customer = 'Viacom' AND DATE(Timestamp) = CURDATE() AND Result = 'Fail' GROUP BY PNR) A 
ON TS.PNR = A.PNR 
SET TS.toShow = '0' ;