• Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.

Ok Got a Server 2008 Sql Express Problem

Status
Not open for further replies.

WarEagleAU

Bird of Prey
Joined
Jul 9, 2006
Messages
10,813 (1.96/day)
Location
Gurley, AL
System Name Pandemic 2020
Processor AMD Ryzen 5 "Gen 2" 2600X
Motherboard AsRock X470 Killer Promontory
Cooling CoolerMaster 240 RGB Master Cooler (Newegg Eggxpert)
Memory 32 GB Geil EVO Portenza DDR4 3200 MHz
Video Card(s) ASUS Radeon RX 580 DirectX 12 DUAL-RX580-O8G 8GB 256-Bit GDDR5 HDCP Ready CrossFireX Support Video C
Storage WD 250 M.2, Corsair P500 M.2, OCZ Trion 500, WD Black 1TB, Assorted others.
Display(s) ASUS MG24UQ Gaming Monitor - 23.6" 4K UHD (3840x2160) , IPS, Adaptive Sync, DisplayWidget
Case Fractal Define R6 C
Audio Device(s) Realtek 5.1 Onboard
Power Supply Corsair RMX 850 Platinum PSU (Newegg Eggxpert)
Mouse Razer Death Adder
Keyboard Corsair K95 Mechanical & Corsair K65 Wired, Wireless, Bluetooth)
Software Windows 10 Pro x64
Ok So I am using the Northwind Database for MySQL 2008 Express Edition. Standard Microsoft database to start learning SQL. This is for school and it is starting to get on my nerves. So here is my problem and lets see if one of you out there can help me. It seems so easy but I cannot wrap my head around it.

Problem: 6. Generate a list of products (ProductName) that have never been ordered (outer join between [Order Details] and Products).

Here is my query:

SELECT Products.ProductName
FROM Products LEFT OUTER JOIN [Order Details]
ON Products.ProductID =
[Order Details].ProductID
WHERE [Order Details].Quantity IS NULL

now this is actually working but it does not return the results I need. The query executes but in the table below it does not show the results I need. Now on Orders and Products they are supposed to be outer joined. You can see that I did do that. Well in Products it has a column heading that says UnitsOnOrder and there are some with 0. Using both 0 and Null is working but not returning the results I need. Anyone have any ideas?
 

WarEagleAU

Bird of Prey
Joined
Jul 9, 2006
Messages
10,813 (1.96/day)
Location
Gurley, AL
System Name Pandemic 2020
Processor AMD Ryzen 5 "Gen 2" 2600X
Motherboard AsRock X470 Killer Promontory
Cooling CoolerMaster 240 RGB Master Cooler (Newegg Eggxpert)
Memory 32 GB Geil EVO Portenza DDR4 3200 MHz
Video Card(s) ASUS Radeon RX 580 DirectX 12 DUAL-RX580-O8G 8GB 256-Bit GDDR5 HDCP Ready CrossFireX Support Video C
Storage WD 250 M.2, Corsair P500 M.2, OCZ Trion 500, WD Black 1TB, Assorted others.
Display(s) ASUS MG24UQ Gaming Monitor - 23.6" 4K UHD (3840x2160) , IPS, Adaptive Sync, DisplayWidget
Case Fractal Define R6 C
Audio Device(s) Realtek 5.1 Onboard
Power Supply Corsair RMX 850 Platinum PSU (Newegg Eggxpert)
Mouse Razer Death Adder
Keyboard Corsair K95 Mechanical & Corsair K65 Wired, Wireless, Bluetooth)
Software Windows 10 Pro x64
Mods please close this thread I had the right information above. Turns out there was not going to be results. Thanks.
 
Status
Not open for further replies.
Top