looking for a query that would achieve the following
i have 2 tbls
each one has a single feild called "colour"
what i want is a query that when the 2 tbls are joined in query and any feilds values are equal do not show these values
ie if red was in tb1 and in tb2 then only show unmatched records
so if tb1 had yellow but not in tb2 then show these results
many thanks in advance