select rom.Romnr, rom.Status
from rom
left join bestillinger
on rom.Romnr = bestillinger.Rom_Romnr
where Ordrenummer not in(select Ordrenummer from bestillinger where(DatoInnsjekk between 20160429 and 20160503) or (DatoInnsjekk between 20160429 and 20160503)) or bestillinger.DatoInnsjekk is null;