Connecting 4 tables - finding some differences between them
you don't need to join all 4 tables, this will show the missing rows

select id, fk_id_chest, x, y from SOL_PUBLIC.COORD@RACDB
minus
select id, fk_id_chest, x, y from SIM_SOL.COORD