Search
InstantDoc ID
GO

Browse By: Author | Issue

June 27, 2008 10:27 PM

T-SQL 101, Lesson 5

How to join tables
Rating: (0)
Bill McEvoy
SQL Server Magazine
InstantDoc ID #99137
Executive Summary: In Microsoft SQL Server 6.5 and earlier, you had to join tables using a laborious technique. With the release of Microsoft SQL Server 7.0, came the JOIN clauses, which provide a much easier way to join tables. Although Microsoft SQL Server 2005 still lets you use the old join technique, future versions of Microsoft SQL Server might not support it. Thus, you should learn how to use the JOIN clauses, no matter whether you're first learning how to join tables or have joined tables for years using the old technique.
...

...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

Compare Member Benefits

Add a Comment

Loved this article. I have printed it off for less knowledgeable users many times for use in understanding how to join tables within data mining applications, such as Crystal Reports from Business Objects. It is clear enough that the inexperienced user can pick up how to join talbes and a great reminder for those of us familiar with joins.

timw 10/15/2008 10:11:03 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.