在MySQL中,给定两个表t1和t2,连接条件为"t1.t2_id=t2.id",如何从t1中获取t2中没有对应记录的记录?( )
EXCLUDING JOIN t2 ON t1.t2_id = t2.id
LEFT OUTER JOIN t2 ON t1.t2_id = t2.id
LEFT JOIN t2 ON t1.t2_id = t2.id WHERE t2.id IS NULL
JOIN t2 EXCLUDING t1.t2_id = t2.id
RIGHT JOIN t2 ON t1.t2_id = t2.id