gistfile1.txt

select * from instance_encounters_mangosR2 where not exists (select * from instance_encounters_mangos where instance_encounters_mangos.entry = instance_encounters_mangosR2.entry 
and 
instance_encounters_mangos.creditEntry = instance_encounters_mangosR2.creditEntry 
and 
instance_encounters_mangos.creditType = instance_encounters_mangosR2.creditType 
and
instance_encounters_mangos.lastEncounterDungeon = instance_encounters_mangosR2.lastEncounterDungeon);


select * from instance_encounters_mangos where not exists (select * from instance_encounters_mangosR2 where instance_encounters_mangos.entry = instance_encounters_mangosR2.entry 
and 
instance_encounters_mangos.creditEntry = instance_encounters_mangosR2.creditEntry 
and 
instance_encounters_mangos.creditType = instance_encounters_mangosR2.creditType 
and
instance_encounters_mangos.lastEncounterDungeon = instance_encounters_mangosR2.lastEncounterDungeon);