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?