SELECT SHIPPING_ITEMS.NAME FROM TRANSACTIONS
  JOIN SHIPPING_ITEMS ON TRANSACTIONS.SHIPPING_ITEM_ID = SHIPPING_ITEMS.ITEM_ID
  WHERE TRANSACTIONS.TRANSACTION_ID = {internalid}