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 > ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
