Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Simple SQL?

Re: Simple SQL?

From: Jan Hidders <hidders_at_REMOVE.THIS.win.tue.nl>
Date: 21 May 2001 07:42:23 GMT
Message-ID: <9eagsv$qmh$1@news.tue.nl> 






Pierre G. Boutquin wrote:


> "Isaac Blank" <izblank_at_yahoo.com> wrote in message

> news:u9XN6.91$At.114013_at_news.pacbell.net...

> >     First, not every SELECT with subqueries can be converted to a

> > join

> 

> Hmmm. Are you sure your assertion is correct?




I think he is. :-) Especially 'NOT IN' and 'NOT EXISTS' subqueries can
usually not be expressed with joins. 


-- 
  Jan Hidders


Received on Mon May 21 2001 - 02:42:23 CDT












Original text of this message













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