June 01, 1999 04:01 PM

T-SQL for Starters: Data Retrieval with Joins

Rating: (0)
SQL Server Magazine
InstantDoc ID #5342
Joining tables yields meaningful information
Databases are not just for storing data, but for retrieving information. Unless you can retrieve relevant information from your database, a powerful server running the latest software is about as much use as a shoebox full of old receipts. You probably normalize your data thoroughly when building your application (for information about normalization, see Michelle Poolet, "Why You Need Data Normalization," Premiere issue), so t...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

good

Anonymous User 8/11/2005 10:51:52 PM


Very clear and concise description of the sometimes cloudy waters of SQL. I was particularly empathetic at your comments about the inadvisability of cross joins (I think they are silly) and the fact that left and right outer joins are basically equivalent.

Excellent basic discussion on joins.

Anonymous User 7/7/2005 9:59:45 AM


Thanks a bunch for these explanations!

Anonymous User 11/1/2004 4:50:01 PM


Hi Guys,
Just wanted to know is a left join statement equivalent to a left outer join statement. I mean is one just a T-sql alias for the other and they prduce the same results everytime?

thx

k

Kirk 2/23/2004 12:03:02 PM


Very useful article.

Benoît Quéval 7/11/2000 8:20:11 AM


You must log on before posting a comment.

Are you a new visitor? Register Here