Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Let we talk about joins..

Author  Topic 

MageshkumarM
Yak Posting Veteran

61 Posts

Posted - 2011-01-03 : 01:19:17
Hi,

i want to do cross join in sql server,
so give me some ideas out the joins in sql server,

Inner join,
Outer join,
Cross join,

Pls help me out of this...!

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-03 : 02:31:32
Why do you want a cross join?

http://www.google.com/search?q=%22Inner+join%22+%22SQL+Server%22
http://www.google.com/search?q=%22Outer+join%22+%22SQL+Server%22
http://www.google.com/search?q=%22Cross+join%22+%22SQL+Server%22

--
Gail Shaw
SQL Server MVP
Go to Top of Page

MageshkumarM
Yak Posting Veteran

61 Posts

Posted - 2011-01-03 : 04:58:50
Pls help me out this,

Tel me simple way to learn type of joins...!


Mag.. :)
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-03 : 05:16:31
Did you take a look at any of those links?

The way to learn joins is to read up what they do (see links), then to test and make sure you understand.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-01-04 : 13:04:50
quote:
Originally posted by MageshkumarM

Pls help me out this,

Tel me simple way to learn type of joins...!


Mag.. :)



look for examples in links posted to understand how joins work and then try it yourself.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -