| Subject | Why this sql not work ? |
|---|---|
| Author | nathanelrick |
| Post date | 2012-03-20T06:46:53Z |
hello,
Select
Field1,
(select ...) AS MyFIELD2
IIF(MyField is null, select ...., Null) As MYField3
From
....
it's not work, it's say unknow "MyField"
but if i replace MyFIELD2 by Field1 it's work ...
is their any workaround to make this SQL work ?
Select
Field1,
(select ...) AS MyFIELD2
IIF(MyField is null, select ...., Null) As MYField3
From
....
it's not work, it's say unknow "MyField"
but if i replace MyFIELD2 by Field1 it's work ...
is their any workaround to make this SQL work ?