Using a select clause in a case statement in TD
Is it possible to somehow use a select clause in a case statement in TD
(rather than doing a join)?
I would like to do something like this:
SELECT
id
, CASE(id IN ANY (SELECT DISTINCT ID FROM PARTICIPANTS_TABLE) THEN 1
ELSE 0 end) AS participant
FROM EVERYONE_TABLE
No comments:
Post a Comment