I'm getting an error on my case statement in SFMC. Is it a simple mistake of syntax?
SELECT *, CASE WHEN status <> 'active' THEN 'active' ELSE status END AS status FROM [sample table] WHERE status <> 'active'
The query's goal is simply to change any non-active status (in this specific data extension) to 'active.' It'll actually be based on a date field, but for now I'm simply having an issue with the case statement.
An error occurred while checking the query syntax. Errors: The column 'status' was specified multiple times for 'Qry'.