|
You can increase search results by using partial words (ie. 'orga% cott%' for 'organic cotton') SELECT COUNT(DISTINCT [VM].company_name) FROM [VM] Inner Join VM_A1 ON [VM].ID = VM_A1.Referral_ID WHERE (Category1 LIKE 'Bed%' OR Category1 LIKE 'Furniture%' OR Category1 LIKE 'Nurser%' OR Category1 LIKE 'Recycling%' OR Category1 LIKE '%Waste%' )--0--Name-or-product--Name-or-product |

Go to


