Access Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top