products order Details productCode VARCHAR(15) productName VARCHAR(70) orderNumb

Question

products order Details productCode VARCHAR(15) productName VARCHAR(70) orderNumber INT(11) productcode VARCHAR( 15) quantityOrdered INT(11) priceE DOUBLE orderlineNumber SMALL IN Indexes productLine VARCHAR(50) productScale VARCHAR(10) productvendor VARCHAR(50) H productDescription TEXT quantityInstock SMALLINT (6) buyPrice DOUBLE MSRP DOUBLE orders orderNumber INT (11) OrderDate DATE requiredDate DATE shippedDate DATE status VARCHAR(15) comments TEXT custom erNumber INT(11 Indexes customerNum ber INT (11) CustomerName VARCHAR(50) contact. astNam e VARCH AR( 50) contacFirstNam e VAR AR(50) phone VARCHAR(20) addressLine1 VARCHAR(45) addressLine2 VARCHAR(45) city VARCHAR(45) state VARCHAR (45) posta Code VARCHAR( 15) country VARCHAR(50)

Explanation / Answer

Solution:

Example of inner join is given below, please let me know if you don't understand it.

SELECT productCode FROM products INNER JOIN orderDetails ON products.productCode= orderdetails.productCode INNER JOIN orders ON orderDetails.orderNumber= orders.orderNumber.

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.