Take the 2-minute tour ×  I am looking for a general response as
to the mindset of how to do this... I have a table that has a
column full of possible parameters and a column full of possible
values. I want to join all parameters of a certain kind to
another table to give further description of those specific
rows, but not have that table joined to all other rows that
don't contain the specific value. It would look like this:
Parameters  Values   Mammal    a          1             b
3    d         cat      Yes    c          4    d         dog
Yes    e          3    d         fish      No    f          2
I've tried a number of ways using Case, however the table just
gets very weird and there was repetition of the table being
joined depending on its length. Any suggestions?  The second
table has two columns, it is being joined on its own animal
column to the values column where parameter = "d". It does not
show up at all when parameter equals anything else. Any
suggestions would be greatly appre