Den 2012-03-20 07:46 skrev nathanelrick s�h�r:

>
> 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 ?
>

Insufficient info, I believe. Give us the full SQL.

>
>

Kjell

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64



[Non-text portions of this message have been removed]