teradata - SQL: case-when statement with "exists" -
I want to be able to set up this field by adding "value to this record, value in some other table I got the bet? "I thought I would try the case-when
with exists
, but teradata (my DBMS) does not like it. Any recommendations?
select foo, (in case when it exists (somedb x to x.bar> as MyFlag from mydb then '1' and '0' end)
It seems that you are unavailable for END
Case
statement?
select foo, (when present (select x.foo from Embedded X where x.bar> 0) then '1' and '0' END as MYFLAG from mydb
Comments
Post a Comment