Missing Fields when using join

• only1rb

  Newbie

  Points: 2

  More actions

  February 3, 2010 at 1:19 am

  #156639

  I have 2 tables Products and ProductSubGroup. I want to get the name of the sub group for the products that have '1' for the DocGroupID. I know the values are there, but I don't understand why I'm not getting the name from the other table. I have tried RIGHT OUTER JOIN, CROSS JOIN, INNER JOIN and variations of all. I have copied the query below. Any Help would be greatly appreciated. Thank you.

  SELECT Products.DocSubGroupID, ProductSubGroup.SubGroupName

  FROM Products LEFT OUTER JOIN

  ProductSubGroup ON Products.DocSubGroupID = ProductSubGroup.id

  WHERE (Products.DocGroupID = 1)

  GroupID SubGroupName

  13NULL

  13NULL

  13NULL

  13NULL

  13NULL

  14NULL

  14NULL

  13NULL

  13NULL

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  February 3, 2010 at 1:30 am

  #1112693

  What results do you get from

  Select * from ProductSubGroup where ProductSubGroup.id =13

  ---

  
  Clear Sky SQL
  My Blog[/url]

• only1rb

  Newbie

  Points: 2

  More actions

  February 3, 2010 at 1:42 am

  #1112697

  Thank you. I am an idiot. I had my connection string pointing to the wrong database. can't retrieve the data if it's not there. DUH!!