Help creating SQL statment with OR
Posted on 2006-11-21
I'm trying to create an SQL which returns any records where 'category' ir equal to any of these four terms: 'Club' 'Club and Bar' 'Restaurant and Club' 'Restaurant, Bar and Club'
My current SQL returns all the records in the database, no matter what is in the 'category' column can someone show me what I'm doing wrong?
rsclubs.Source = "SELECT * FROM entertainment WHERE category = 'Club and Bar' OR 'Club' OR 'Restaurant and Club' OR 'Restaurant, Bar and Club' ORDER BY ID DESC"