1. 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

Discussion in 'General Software' started by WarEagleAU, Oct 6, 2010.

Thread Status:
Not open for further replies.
  1. WarEagleAU

    WarEagleAU Bird of Prey

    Joined:
    Jul 9, 2006
    Messages:
    10,809 (2.66/day)
    Thanks Received:
    548
    Location:
    Gurley, AL
    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?
     
    10 Year Member at TPU
  2. WarEagleAU

    WarEagleAU Bird of Prey

    Joined:
    Jul 9, 2006
    Messages:
    10,809 (2.66/day)
    Thanks Received:
    548
    Location:
    Gurley, AL
    Mods please close this thread I had the right information above. Turns out there was not going to be results. Thanks.
     
    10 Year Member at TPU

Currently Active Users Viewing This Thread: 1 (0 members and 1 guest)

Thread Status:
Not open for further replies.