sethbeckerman5 Staff asked 4 years ago
I'm new to databases. So, I got two tables and , and I need to make a query that prints the sold out products alongside some supplier information.
table:
Product_ID
Product_Name
Quantity
Supplier_ID
1
water
0
11
2
Milk
26
12
3
eggs
8
12
4
5L water
19
11
5
water gallon
0
11
table:
Supplier_ID
Supplier_Name
Supplier_Phone
11
Pure life
55555555
22
Dairy
77777777
33
Nivea
66666666
My work so far:
The output:
Error Code: 1054. Unknown column 'product.Supplier_ID' in 'on clause'
the desired output:
Product_Name
Quantity
Supplier_Name
Supplier_Phone
water
0
Pure life
55555555
water gallon
0
Pure life
55555555