SQL Select Statement Trouble

Posted on 2007-11-30
Last Modified: 2010-03-20
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!!
Question by:grogo21
  • 2
  • 2
LVL 47

Accepted Solution

Wayne Taylor (webtubbs) earned 250 total points
ID: 20386832
SELECT     COLOR.Color, COLOR.GenericColor, PRODUCTS.Brand
                      PRODUCTS ON COLOR.Color = PRODUCTS.Color
WHERE     (PRODUCTS.Brand = 'Brand1')
LVL 61

Assisted Solution

mbizup earned 250 total points
ID: 20386834
SELECT Select Color.Color, Color.GenericColor, Products.Brand
FROM Color INNER JOIN Products ON  Color.Color = Products.Color
WHERE Products.Brand = 'Brand1'

Author Comment

ID: 20387069
What if its not comming up with any results?  
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 20387074
Then you have no matches.

Author Comment

ID: 20387190
Never mind, it was an issue with a relationship.  I am getting results now.  Query works great!!  Thanks

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question