|
You can increase search results by using partial words (ie. 'orga% cott%' for 'organic cotton') SELECT COUNT(DISTINCT [GT].company_name) FROM [GT] Inner Join GT_A1 ON [GT].ID = GT_A1.Referral_ID WHERE (Category1 LIKE 'Clothing%' OR Category1 LIKE 'Gifts%' OR Category1 LIKE 'Office%' OR Category1 LIKE 'Pharma%' OR Category1 LIKE 'Florist%' OR Category1 LIKE 'Fabric%' )--0--Name-or-product--Name-or-product |

Go to


