table category - table filled with categories - for example 30 different categories
I have two look up tables
Table 1 - look up table stores the categories that EACH user can assign themselves to
(contains userID and CategoryID)
- Multiple users can assign themselves to multiple categories
Table 2 - look up table stories the the categories EACH resource can assign itself to
(contains resourceID and CategoryID)
- Multiple resources can be assigned to multiple categories
Is there one query which will pull back a list of the distinct categories that appear in either of the look up table.
For example there are 30 categories
Lookup table 1 has 10 records - only 6 of them are Unique categories
Lookup table 2 has 20 records - only 2 of theses are unique when you take into account the 6 found in the other table
in total I would like my query to return the 8 distinct categories out of the 30 in the categories table.
Hope that makes sense?
Thanks in advance.