Could youplease help me on this MySQL question. PLease do this in MySQL. and sen
ID: 3740138 • Letter: C
Question
Could youplease help me on this MySQL question. PLease do this in MySQL. and send me the result also please. Appricite your help.
Using multiple-table queries and joins, complete the following tasks (see database below).
1. For each part, list the part number, description, units on hand, order number, and number of units ordered. All parts should be included in the results. For those parts that are currently not on order, the order number and number of units ordered should be left blank. Order the results by part number
This is the MySQL database
Explanation / Answer
For each part, list the part number, description, units on hand, order number, and number of units ordered. All parts should be included in the results. For those parts that are currently not on order, the order number and number of units ordered should be left blank. Order the results by part number
SELECT PR.PART_NUM, PR.DESCRIPTION, PR.ON_HAND, OL.ORDER_NUM, OL.NUM_ORDERED FROM PART PR, ORDER_LINE OL
LEFT JOIN ORDER_LINE AS OL ON PR.PART_NUM = OL.PART_NUM;