AndrewCorkery
Technical User
Hi,
I have a query that I wish to limit data retrieved based on data from another table.
The field contains data of many country names and I only want to return country names that are NOT included in a seperate table.
The field below contain data that needs to be queried:
Country Name
Singapore
Singapore
Singapore
Singapore
Singapore
South Africa
South Africa
South Africa
United Kingdom
United Kingdom
United Kingdom
United States
United States
United States
AUSTRALIA
NEW ZEALAND
This is the table that I wish to use to query and excluded records from the above table if they are equal.
CountryFullName
AUSTRALIA
NEW ZEALAND
PAPUA NEW GUINEA
I have a query that I wish to limit data retrieved based on data from another table.
The field contains data of many country names and I only want to return country names that are NOT included in a seperate table.
The field below contain data that needs to be queried:
Country Name
Singapore
Singapore
Singapore
Singapore
Singapore
South Africa
South Africa
South Africa
United Kingdom
United Kingdom
United Kingdom
United States
United States
United States
AUSTRALIA
NEW ZEALAND
This is the table that I wish to use to query and excluded records from the above table if they are equal.
CountryFullName
AUSTRALIA
NEW ZEALAND
PAPUA NEW GUINEA