Can someone summarize when subqueries are required.  I thought
aggregates often needed them, but I see now that table aliases can do it
in most cases.  I think NOT IN can not be done without subqueries.

Is there a general rule on this?  A rule about correlated subqueries?

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 31 Dec 1999 01:08:01 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
When are subqueries needed