[ic] query with

[Greg Goble]

Hi folks,

IC4.8.5

In transactions I have a column 'country'.

How can I additionally group these countries into regions. I want to perform
a  [query] whereby I do _???_ so that certain counties fall into certain
regions on the results. E.g.:

Germany, Austria, France, ... = EUR (Europe)
Togo, South Africa, ... = AF (Africa)
Phillipines, Thailand, ... = EA (East Asia)

What I'm after would be:
select distinct country where country = 'EUR' ...

Thx, Greg G.