#author("2019-11-06T12:52:55+08:00","default:Admin","Admin") .NET Framework
Web開発
Database
IoT
文法
Select文中のIF ELSEの例:
select Table1.Id, (Case WHEN Table1.ChildId = NULL Then Table1.ChildValue Else (select value from Table2 where Table2.ID = Table1.ChildId) -- 必ず括弧付ける End) as Comment, Form Table1
コメント: