Hi Cadavre,
For some reason I can't get the code to work:( I did run those two select statements.
SELECT COUNT(*)
FROM tbm_persnl_bud a
LEFT OUTER JOIN _TBM_Persnl_Bud_Update b ON a.EMPL_UNO=b.EMPL_UNO AND a.MONTH = b.MONTH
WHERE b.EMPL_UNO IS NULL;
Returns: 6544
and
SELECT COUNT(*)
FROM _TBM_Persnl_Bud_Update a
LEFT OUTER JOIN tbm_persnl_bud b ON a.EMPL_UNO=b.EMPL_UNO AND a.MONTH = b.MONTH
WHERE b.EMPL_UNO IS NULL;
Returns: 3624