Please use PHPMYADMIN to answer this questions CUSTOMER Phone should keep the da

Question

Please use PHPMYADMIN to answer this questions

CUSTOMER Phone should keep the dashes Country+ Canada United States Germany Australia United States Phone 555-9888 555-8184+ 833-8483 842-4850+ 110-9493 CustomerlD Name Mitch Connore Professor Chaos Al Gorep Jerry Seinfeld Bruce Wayne 2p 3p 5P ORDERS PartID 72 OrderID 10308v 1030% 10310- 10311+ CustomerlD 50 2p ShippingDate 2015-09-12 2014-12-01+ 2016-04-22' 2016-08-18 90P 26 50 STOCK PartID 11p 26 72 90P 109 PartName Beer Wrench+ Scotchp Drillv Benche Quantityo 72 12 34P 62

Explanation / Answer

Following is the answer:

step1:

select o.OrderId, o.CustomerId, s.PartId, s.PartName, s.Quantity from orders o, stock s where o.PartId = s.PartId and o.CustomerId = 5

step2:

SELECT *
FROM customer c, orders o
WHERE c.CustomerId = o.CustomerId
LIMIT 0 , 30

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---