|
You can increase search results by using partial words (ie. 'orga% cott%' for 'organic cotton') SELECT COUNT(DISTINCT [LH].company_name) FROM [LH] Inner Join LH_Hotel ON [LH].ID = LH_Hotel.Referral_ID WHERE (Category1 LIKE 'Travel%' OR Category1 LIKE 'Hotel%' )--0--Name-or-product--Name-or-product |

Go to


