"cascade" table dependencies : how to do this query ?
Basically my datamodel is the one attached.
My question is : how do I get a list of COUNTRIES for which NO CITY is involved in any travel (meaning : no city of the country(ies) returned is/are ever listed as a departure or destination in the travel table).
I suspect FM doesn't like my dependency between the city and travel tables thus I never get the results I want.
Thanks a lot !