SQL Select Statement Trouble

Hello, I am stuck and need help writing a sql statement.  In access I have these tables:
COLOR Table Contains Color, GenericColor Columns
PRODUCTS table contains Color, Brand Columns

I need to Select Color.Color, Color.GenericColor, Products.Brand.   But only select Color.Color and Color.GenericColor where Color.Color = Products.Color and the brand from the Products table = 'Brand1'  Thanks Very Much!!
grogo21Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Wayne Taylor (webtubbs)Connect With a Mentor Commented:
SELECT     COLOR.Color, COLOR.GenericColor, PRODUCTS.Brand
FROM         COLOR INNER JOIN
                      PRODUCTS ON COLOR.Color = PRODUCTS.Color
WHERE     (PRODUCTS.Brand = 'Brand1')
0
 
mbizupConnect With a Mentor Commented:
SELECT Select Color.Color, Color.GenericColor, Products.Brand
FROM Color INNER JOIN Products ON  Color.Color = Products.Color
WHERE Products.Brand = 'Brand1'
0
 
grogo21Author Commented:
What if its not comming up with any results?  
0
 
Wayne Taylor (webtubbs)Commented:
Then you have no matches.
0
 
grogo21Author Commented:
Never mind, it was an issue with a relationship.  I am getting results now.  Query works great!!  Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.