I am trying to create a query off a table to generate data based on multiple conditions.
SELECT
"EmployeeID",
"FirstNameLastName",
"FormattedDate",
"Hours",
"ActivityText"
FROM "Eagle_SAP_TimeTickets"
WHERE "ActivityText" = 'Non Productive Time - General Admin'
I'd like for it to also generate for three additional WHERE conditions, which are
'Non Productive Time - Meetings'
'Non
Productive Time - Shop'
'Non Productive Time - Training'
When I write the query as the following it fails...
SELECT
"EmployeeID",
"FirstNameLastName",
"FormattedDate",
"Hours",
"ActivityText"
FROM "Eagle_SAP_TimeTickets"
WHERE "ActivityText" = 'Non Productive Time - General Admin' OR 'Non Productive Time - Meetings' OR 'Non Productive Time - Shop' OR 'Non Productive Time - Training'
Any suggestion on how to fix this? Thank you for your help