Solved

SQL Select Statement Trouble

Posted on 2007-11-30
5
186 Views
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!!
0
Comment
Question by:grogo21
  • 2
  • 2
5 Comments
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 250 total points
Comment Utility
SELECT     COLOR.Color, COLOR.GenericColor, PRODUCTS.Brand
FROM         COLOR INNER JOIN
                      PRODUCTS ON COLOR.Color = PRODUCTS.Color
WHERE     (PRODUCTS.Brand = 'Brand1')
0
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 250 total points
Comment Utility
SELECT Select Color.Color, Color.GenericColor, Products.Brand
FROM Color INNER JOIN Products ON  Color.Color = Products.Color
WHERE Products.Brand = 'Brand1'
0
 

Author Comment

by:grogo21
Comment Utility
What if its not comming up with any results?  
0
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
Comment Utility
Then you have no matches.
0
 

Author Comment

by:grogo21
Comment Utility
Never mind, it was an issue with a relationship.  I am getting results now.  Query works great!!  Thanks
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

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…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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.

762 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now