INSERT INTO T_LS (FULLPATH, DIRNAME, LEVEL, FIRSTDETECTED, LASTVERIFIED) SELECT FULLPATH , DIRNAME , LEVEL , FIRSTDETECTED , LASTVERIFIED FROM T_LS_TMP left outer join T_LS on T_LS_TMP.FULLPATH=T_LS.FULLPATH and T_LS.LASTVERIFIED = (SELECT max(LASTVERIFIED) FROM T_LS) WHERE T_LS.FULLPATH IS NULL;