ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
  How to Misuse SQL's FROM Clause
Subject:   Correct Use of FROM Clauses
Date:   2004-10-01 09:18:59
From:   Trackback from http://xn.pinkhamster.net/blog/tech/correct_use_of_from_clauses.writeback anonymous2

There's an interesting
article by Stéphane Faroult on ONLamp about when to use subselects rather than JOINs
in SQL queries. He says that only tables from which you are returning columns
or those tables necessary to join such tables should appear in the