Solved

SQL Select Statement Trouble

Posted on 2007-11-30
5
197 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
ID: 20386832
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
ID: 20386834
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
ID: 20387069
What if its not comming up with any results?  
0
 
LVL 47

Expert Comment

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

Author Comment

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

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

932 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

11 Experts available now in Live!

Get 1:1 Help Now