In another table called items
I need to select the description field for a value called item_key that matches the above two fields sr_item_key and nb_item_key
so that my output would be
sr_item_key description nb_item_key description
(the item_key in items table will match sr_item_key and nb_item_key) so need to reference each different description and return it based on that.
This will only return the description based on the first sr_item_key and not the second one (obviously) all my join efforts have failed with syntax errors
from it_xref i, items t
where i.nb_item_key = t.item_key