sorry, my fault i want to say

Select
(select ...) AS MyFIELD2
IIF(MyField2 is null, select ...., Null) As MYField3
From

--- In firebird-support@yahoogroups.com, Kjell Rilbe <kjell.rilbe@...> wrote:
>
> 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]
>