Posting from the Informix-list

digicom/Jeevan, If by "conditions" you mean subquery on the from clause, Please read the manuals about temp tables. I guess You would be able to achieve the same results by using temp tables as by doing a subquery on the FROM clause. So it is "available" in Informix. If you still have problems , clearly state what you are trying to achieve by using the "conditions in from clause" & we'd try to help. ---------- From: Jeevan Nair [SMTP:jgnair@hotmail.com] Sent: Friday, September 08, 2000 6:52 AM To: kagel@bloomberg.net; informix-list@iiug.org Subject: Re: CONDITIONS IN IN FROM CLAUSE This method is possible only in datawarehousing environments. I am aware of it possible in Sybase IQ, Teradata. It is not available in any Informix online engine or AD/XP products. Jeevan >From: "Art S. Kagel" <kagel@bloomberg.net> >Reply-To: kagel@bloomberg.net >To: informix-list@iiug.org >Subject: Re: CONDITIONS IN IN FROM CLAUSE >Date: Thu, 07 Sep 2000 13:26:46 -0400 > >digicom wrote: > > > > IS IT POSSIBLE TO PUT CONDITIONS IN THE FROM CLAUSE. I KNOW IN SQL >SERVER IT > > IS POSSIBLE. IF IT'S NO POSSIBLE, I WANT TO KNOW WHAT ANOTHER CHOICES I >HAVE > > TO GET MORE SPEED IN MY SELECT CONDITIONS. THANKS!!! > >What are you trying to accomplish? > >What do you mean more speed in select conditions? > >Relate the problem and we'll relate the Informix-ish solution. > >Art S. Kagel _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.