Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.
i.item, u.UOM
FROM dbo.inItems i
INNER JOIN dbo.inUOM u ON
u.item = i.item AND
u.uom NOT IN ('GR', 'KG')
ORDER BY
i.item, u.UOM
If you want to list an item even if it has no (other) uom, use a LEFT OUTER JOIN instead of an INNER JOIN.