>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