|
|
Log in
Sign Up
相关文章推荐
|
要出家的钥匙扣 · 比亚迪汉、几何C、蔚来EC6领衔，下半年5款 ...· 6 月前 · |
|
|
潇洒的蚂蚁 · 团学工作_中国人民大学哲学院· 1 年前 · |
|
|
温文尔雅的紫菜汤 · jquery修改整个页面的字体大小_mob6 ...· 1 年前 · |
|
|
兴奋的沙滩裤 · 果不其然，宁德时代在美电池工厂项目或被叫停， ...· 2 年前 · |
|
|
痴情的铁板烧 · 哥布林洞窟 - 百度· 2 年前 · |
How do I add a if condition in SQL Query?
Hi Community,
I am looking to add an if condition in the query.
Something like this:
if {Notification).[SMSSeen]=1 , then run the LEFT JOIN {UserSMSRespond} ON {UserSMSRespond}.[MobileNumber] = {Ticket}.[ContactNo] else don't need run but assign {UserSMSRespond} .[Message] = " " (empty)
Hi Alvin,
You can use the CASE command to control the field output.
So on your SELECT statement, instead of {UserSMSRespond}.[Message] you want to add CASE WHEN {Notification}.[SMSSeen] = 1 THEN {UserSMSRespond}.[Message] ELSE '' END
The syntax for the CASE is: CASE (condition) THEN (output) ELSE (output) END .
In this case you control which value your field will have.
Regarding the LEFT JOIN you will need to have it there to be able to use the {UserSMSRespond}.[Message] (in case {Notification}.[SMSSeen] = 1).
Hope it helps.
Cheers,
João
Hi Alvin,
i think you need to try like this
if @SMSSeen=1
your sql statement
Else
without join sql statement
or you can see some case in sql join
https://stackoverflow.com/questions/10256848/can-i-use-case-statement-in-a-join-condition
Regards
Rahul