sorry, my fault i want to say Select (select ...) AS MyFIELD2 IIF(MyField2 is null, select ...., Null) As MYField3 From
--- In [email protected], 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] >
