|
AskSQLTeam
Ask SQLTeam Question
USA
0 Posts |
 Posted - 04/17/2006 : 10:48:38
|
nmar writes "Dear Sirs,
I would like to use IF instead of CASE in SELECT Statement.
example :
SELECT FIELD11, FIELD12,
CASE WHEN FIELD13 > (SELECT SUM(FIELD23)
FROM TBL2
WHERE TBL1.FIELD11 = FIELD21
)
THEN
(SELECT SUM FIELD24)
FROM TBL2
WHERE TBL1.FIELD11 = FIELD21
)
ELSE
'NO VALUE'
END
AS 'MYCOLUMN'
FROM TBL1 TBL1
Please, how I can use IF instead of CASE (with CASE works fine.)" |
|
IF ELSE in SELECT STATEMENT
