CONDITIONS IN IN FROM CLAUSE

Posted in 2000

digicom — Thu, 07 Sep 2000 10:29:03 GMT — source: Informix-list mailing list archive (1991-1998)

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!!!

↪ replying to digicom

Doug Agnew — Thu, 7 Sep 2000 09:45:23 -0400 — source: Informix-list mailing list archive (1991-1998)

What sort of conditions would you need to put in the FROM clause that could not be placed in the WHERE clause (other than JOIN conditions, of course). And by the way, PLEASE STOP SHOUTING!!!! We're not deaf. Doug. "digicom" <digicom@cecot.es> wrote in message news:P5Kt5.145$MA5.2148@m2newsread.uni2.es... > 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!!! > >

↪ replying to digicom

Art S. Kagel — Thu, 07 Sep 2000 13:26:46 -0400 — source: Informix-list mailing list archive (1991-1998)

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