I have two tables.
One shipment can contain more items.
When I now do this select I get all items per shipment.
SELECT SH.shipm_ID, IT.it_name
INNER JOIN IT
ON SH.shipm_ID = IT.shipm_ID;
How can I make a select where I get only the first occurence of an item.
So a JOIN and TOP 1 combined.