Need view to compare Muliple rows in table 1 to multiple rows in table 2 and give one result
I have two tables. One table contains records where a unique item (x) may associate with several bits. I have another table which assoicates thost bits with a seperate unique code (x'). For example:
a 1 x 1
a 2 x 2
a 3 y 1
a 4 y 2
a 5 y 3
What I'd like to have is a veiw that tells me x is a b because of its combination and y is a c because of its combination, but niether are a because of the required combination. I haven't been able to figure out how to put the view together and I'm hoping it's just a mental margarita on my part. Any ideas?