|
You can increase search results by using partial words (ie. 'orga% cott%' for 'organic cotton') SELECT COUNT(DISTINCT [AH].company_name) FROM [AH] Inner Join AH_A1 ON [AH].ID = AH_A1.Referral_ID WHERE (Category1 LIKE 'Restaurants%' OR Category1 LIKE 'Wine Bar%' OR Category1 LIKE 'Coffee%' OR Category1 LIKE 'Juice%' OR Category1 LIKE 'Chocola%' OR Category1 LIKE 'Baker%' )--0--Name-or-product--Name-or-product |

Go to


