select
t.slotmachinebk,
t.gamingdate,
t.freeplaydownloaded,
t.freeplayadjusted,
t.freeplayplayed,
t.freeplayabandoned,
t.freeplaybalance
from (select * from freeplay.egmfreeplay union all select * from Change.EgmFreePlay) t where not exists (select * from testtable where
slotmachinebk = t.slotmachinebk and
auditdate = t.gamingdate and
freeplaydownloaded = t.freeplaydownloaded and
freeplayadjusted = t.freeplayadjusted and
freeplayplayed = t.freeplayplayed and
freeplayabandoned = t.freeplayabandoned and
freeplaybalance = t.freeplaybalance)
select
t.slotmachinebk,
t.gamingdate,
t.freep