Gamic

What you really want is something that looks like this: update a set approval_date = b.date from <tableName> a join <tableName> b on a.id = b.parentid where a.approval_date <= '1 Jan 1970' --rest of where clause