I have a table which has a list of countries, and another with details of which hotels within these countries have paid money. I have grouped this table so that i have a list of countries which have paid money. I then created a query with both tables, which have a relationship based on Country names, the problem is where a country hasnt contributed, it returns a blank where id like 0's