How to Misuse SQL's FROM Clause (74 tags)
Many SQL queries misuse their
FROM clauses. Misuse them? That's right. Stéphane Faroult explains this common mistake and demonstrates how two types of subqueries can improve performance and reliability.
Configuring Database Access in Eclipse 3.0 with SQLExplorer (28 tags)
It's 2005 and you're using Eclipse. Should you still be creating your database tables and seeding them with data by hand, from an SQL command-line utility? Deepak Vohra introduces the SQLExplorer plugin for Eclipse, which allows you to put a GUI on your development-time database access.
Managing Many-to-Many Relationships with PL/pgSQL (18 tags)
SQL gives you plenty of options for handling relationships--you can use joins and database relations, or you can make multiple queries and write complex logic on the client. What are the benefits and drawbacks of each? David Wheeler recently experimented with moving complex relationship logic into PostgreSQL's PL/pgSQL language; the results were stunning.
Hierarchical SQL (16 tags)
Conventional wisdom claims that it's difficult to model hierarchical relationships in relationally minded SQL. Actually, it's easier than you think. Joe Celko explains one method of representing trees in SQL.
The Outer Limits of SQL JOINs (14 tags)
In the last column, John Paul Ashenfelter showed you how to use inner joins and cross joins. This week he tackles outer joins.