求供应工程J1零件的供应商号码SNO

- 求供应工程J1零件的供应商号码SNOselect sno from spjwhere jno = ‘j1’select distinct sno from spjwhere jno = ‘j1’