The original poster can also create a view with the filter I mentioned above and a synonym for each schema.
Another option would be to create a view for each schema that filtered on country and then create a synonym
for each view for its respective schema. There are a dozen ways to do this, just pick one.

It's not that I don't like bud, but you can't ship that kind of thing through the mail if you catch my drift...
Actually, I only drink stout beer... Where is Mr. Hanky when you need him, we are venturing into his turf.