RE: CONDITIONS IN IN FROM CLAUSE

Posted in 2000

Bernstein, Rick — Thu, 7 Sep 2000 11:54:24 -0700 — source: Informix-list mailing list archive (1991-1998)

IDS 7.31 and IDS 9.21 support ANSI join syntax where join conditions are specified in the FROM statement. For example: SELECT * FROM (tab1 JOIN tab2 ON tab1.c1 = tab2.c1) LEFT JOIN tab3 ON tab2.c1=tab3.c1 WHERE tab1.c2 > 10 Is this what you are asking? What problem are you trying to solve? What is your Informix engine version? -----Original Message----- From: digicom [mailto:digicom@cecot.es] Sent: Thursday, September 07, 2000 03:29 To: informix-list@iiug.org Subject: CONDITIONS IN IN FROM CLAUSE 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!!!