Access Query

[Guest]

I have 2 tables, table 1 contains product info, inc a colum called Short
description. In table 2 I have a list of recognised brands names. What I want
to do is write a query that will return two colums, the Short Description,
and the brand name. The brand name should only appear if any of the Brand
names listed in the brands table exist in the short description?

 

[David Seeto via AccessMonster.com]

Does this mean you only want to display products that have a recognised
Brand? If so, then aa straightforward inner join should do the job:
select ProductCode, ProductName, BrandName
from ProductInfo inner join BrandNames
on ProductInfo.ShortDescription = BrandNames.BrandName