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!!