MySQL Delete with left join

delete term_node FROM term_node LEFT JOIN term_data AS td ON term_node.tid=td.tid WHERE td.vid = 2 AND term_node.nid = 5289
Knowledge keywords: