Anyone know if it's possible to code this as part of a WHERE clause of a SELECT?
DEGEST must exist where COM is between 01/08/15 and 31/07/16
and AIM is in (020, 021 or 031) unless CTRY exists
I can code it ok until the last part i.e. coding the 'unless CTRY exists
Any help appreciated