Re: Correlated Subqueries allowed in FROM clause?

From: Jack Guyant <jackg_at_aloha.net>
Date: Mon, 14 Jun 1999 21:01:10 -1000
Message-ID: <7k65v0$qsg$1@nuhou.aloha.net>

For openers, Oracle (whether 8 or otherwise) does not support the INNER JOIN syntax of Access. An equijoin in Oracle is expressed in the WHERE clause such as:

WHERE table1.field_a = table2.field_a

The most common implementation of a correlated subquery in Oracle to which I'm accustomed uses the EXISTS or NOT EXISTS.

I can provide more details if you wish to pursue this.

Jack Guyant
jackg_at_aloha.net Received on Tue Jun 15 1999 - 02:01:10 CDT

This message: [ Message body ]
Next message: Raj Gabrielse: "tracking single-statement insert"
Previous message: Andy Hardy: "Re: Export times: affected by size of table or amount of data?"
In reply to: mitch23_at_hotmail.com: "Correlated Subqueries allowed in FROM clause?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US