English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

Given the relation Parts containing the attributes PartName, and SupplierID as well as teh relation Suppliers containing the attributes SupplierID, Address, FaxNumber, write an SQL statement to obtain the supplier identifications and fax numbers for all the suppliers that supply the part whose part number is X4J26

2007-11-29 22:39:11 · 3 answers · asked by Cap10kirk 3 in Computers & Internet Programming & Design

3 answers

select distinct supplierID, FaxNumber
from parts join supplier
where partnumber=x4j26

i think this is wat u need \
gud luck

2007-11-29 22:45:25 · answer #1 · answered by sun 2 · 0 0

YOu need a vacation,,,get in touch with mother earth!!

2007-11-29 22:41:25 · answer #2 · answered by E S 3 · 0 0

i don't no

2007-11-29 22:43:45 · answer #3 · answered by Anonymous · 0 0

fedest.com, questions and answers