>>select distinct SUPPL_FK ; >> from ITEMS >>
>select SUPPL_PK,SUPPL_NME from SUPPLIERS where SUPPL_PK in ; > (select DISTINCT SUPPL_FK FROM ITEMS) ORDER BY SUPPL_NME >