Thanks for helping me
Could you change your display name?
OEHR_LOCATIONS a, OEHR_COUNTRIES b
group by b.COUNTRY_ID,b.REGION_ID
order by b.COUNTRY_ID desc
yeah .. "deleting" this thread isn't going to happen.
Instead of removing your post and recreating it elsewhere, just mark the thread as "assumed answer".
Sorry about this, i understand now