--- Andrew Jorgensen <[EMAIL PROTECTED]> wrote: > More importantly (IMHO) subselects are a more elegant > way to express your query. It's probably true that you > can convert almost any subselect to a left outer join, > but that's just not an elegant way to do it, nor is it > intuitive.
Sub-queries are often a more readable way to express the query, that's true. > BTW: If any subselect can be expressed as a join why > can't the DB server just do that conversion for me? It usually does :) ===== PGP Key ID: 071B173D Fingerprint: ED30 B048 6833 56B4 28C0 CE52 F12B 884A 071B 173D __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus ____________________ BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________ List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
