I have been trying the following but I am getting more rows than I bargained for:
select cust.customer_id, cou.country_name
from customer cust, country cou
where cust.country_id = cou.country_id
posted 6 years ago
I've just knocked up a test database to match that, and the query you've just given gives you what you want. The result you describe is what you'd get if you omitted the "where..." part of that query. Are you sure that's the query that's actually getting run?
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads