Is there a field called MyField in your table? If not, this "error" is
correct. If its not there it will always return Unknown. You have to
refer to an existing "real" field before you can use an alias.

Alan J Davies
Aldis

On 20/03/2012 06:46, nathanelrick wrote:
> 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 ?
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com <http://www.avg.com>
> Version: 2012.0.1913 / Virus Database: 2114/4880 - Release Date: 03/19/12
>