I have 3 fields for categories, ie one company can have more than 1
There are 64 categories in total.
One company could be dealing with catgeories 1 and 10; another
categories 20 and 30.
Thus for each record there are 3 fields for category data, If a
company decides that it deals wtih category 20 only, the other 2
fields are empty.
Campanies are situated at different region. For a given region I need
to come up with a sorted distinct list (ie no repeat) from these 3
I am not sure about SQL. Can SQL experts give me some tips.