Tuesday, 10 September 2013

Using a select clause in a case statement in TD

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