CREATE PROCEDURE sp_Q1
"at"country1 NVARCHAR(15),
"at"country2 NVARCHAR(15)
SELECT SupplierID, CompanyName, Phone, Country FROM suppliers where Country in ("at"country1,"at"country2)
SELECT ProductID, ProductName, UnitPrice, SupplierID FROM Product
where SupplierID in(
SELECT SupplierID FROM suppliers
where Country in ("at"country1,"at"country2)) ORDER BY SupplierID
<h3> What is product supplier?</h3>
PRODUCT SUPPLIER ProductD Supplier Description Contact Name Cost Phone Number PRODUCT (ProductiD. Description. Cost) SUPPLIER (Supplier D. ContactName PhoneNumber, Productio) PRODUCT (ProductID. Description, Cost ContactName) SUPPLIER (Supplier D. ContactName, PhoneNumber)
PRODUCT (ProductID. Description. Cost) SUPPLIER (Supplier D. ContactName, PhoneNumber) PRODUCT (Product Description, CostSupplier) SUPPLIER (Supplieri. ContactName, Phone Number, ProductID) PRODUCT (ProductID. Description Cost Supplieri) SUPPLIER (Supplierib. ContactName, PhoneNumber)
Therefore, SELECT ProductID, ProductName, UnitPrice, SupplierID FROM Product
where SupplierID in(
SELECT SupplierID FROM suppliers
where Country in ("at"country1,"at"country2)) ORDER BY SupplierID
Learn more about SupplierID on:
brainly.com/question/15698840
#SPJ1
