1. DELETE FROM yw_fkdb c WHERE c.fkdbh in (SELECT a.fkdbh FROM yw_fkdb a LEFT JOIN yw_jjdb b ON a.jjdbh=b.jjdbh WHERE b.jjdbh ISNULL)