SQL CASE Question
- by docsql
Hiya,
I dont know if this can be done but i'd though i'd ask.
What I want to do is have a case statement query and if a 1 begin another action. if 0 dont do anything.
For Example
select CASE WHEN client.deathofdeath = yes THEN 1
do another select in here (which is another table)
Else 0 End AS DeathDate
From Client client
Can this be done?