a good reference for learning differnet Joins in SqlServer 200

Is there a good document for learning different joins in Sqlserver? .I have
seen some of them on the net but not very helpful .
ThanksHi Ray
Books online is the first call for anything to do with SQL Server. The
latest version can be downloaded from
http://www.microsoft.com/sql/techin.../2000/books.asp
The topics "Using Joins"
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\acd
ata.chm::/ac_8_qd_09_3mk3.htm
and "Join Fundermental"
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\acd
ata.chm::/ac_8_qd_09_610z.htm
(which if installed in the default location you can post the above links
into the GO menu option) should give you a reasonable understanding of the
types of join available and examples you can test on the example databases.
John
"RayAll" <RayAll@.microsft.com> wrote in message
news:Ol%23PD2FHFHA.3912@.TK2MSFTNGP10.phx.gbl...
> Is there a good document for learning different joins in Sqlserver? .I
> have seen some of them on the net but not very helpful .
> Thanks
>|||Thanks John,
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23BtIpENHFHA.2924@.TK2MSFTNGP15.phx.gbl...
> Hi Ray
> Books online is the first call for anything to do with SQL Server. The
> latest version can be downloaded from
> http://www.microsoft.com/sql/techin.../2000/books.asp
> The topics "Using Joins"
> mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\a
cdata.chm::/ac_8_qd_09_3mk3.htm
> and "Join Fundermental"
> mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\a
cdata.chm::/ac_8_qd_09_610z.htm
> (which if installed in the default location you can post the above links
> into the GO menu option) should give you a reasonable understanding of the
> types of join available and examples you can test on the example
> databases.
> John
> "RayAll" <RayAll@.microsft.com> wrote in message
> news:Ol%23PD2FHFHA.3912@.TK2MSFTNGP10.phx.gbl...
>