SELECT ITEMUSED_ID
, JOBNO
, ITEMNO
, QTY
, CAT1
FROM ITEMSUSED
JOIN CATEGORY1 C1 ON C1.CAT1NO=(SELECT CAT1NO FROM ITEMS WHERE
ITEMS.ITEMNO=ITEMSUSED.ITEMNO)

seems to work fine too! I guess this is the preferred option(?)

Steve