I’m trying to delete rows based on a inner join and for some reason, it is failing. if I echo the $sqlRequest with the variables replaced and paste it in my MySQL, it works. Every other queries I do, except this one.
$sqlRequest = 'DELETE j FROM `Active_PSManager`.`jobs` AS j INNER JOIN `Active_PSManager`.`tasks` AS t ON t.GUID = j.AssignedTask WHERE t.Initiator = "' . $setupguid . '";';