Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Understanding INNER join in detail Expand / Collapse
Author
Message
Posted Monday, July 07, 2008 10:20 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, March 06, 2014 4:48 AM
Points: 52, Visits: 270
Comments posted to this topic are about the item Understanding INNER join in detail

Susantha
Post #529749
Posted Tuesday, July 08, 2008 12:53 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, March 24, 2010 2:08 AM
Points: 503, Visits: 10
Good Article and it really gives you a clear picture of Inner join..

Good One....
:)
Post #529786
Posted Tuesday, July 08, 2008 1:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 08, 2008 5:03 AM
Points: 1, Visits: 4
The result of Q4 & 5 confuses me. Why is the combination of 5--5 not included and aren't the keys switched??
Post #529796
Posted Tuesday, July 08, 2008 1:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 2:08 PM
Points: 62, Visits: 268
whoa. dude really needs an editor.
Post #529799
Posted Tuesday, July 08, 2008 1:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 22, 2010 4:37 AM
Points: 1, Visits: 5
I think the output pictures for query 4 and query 5 are incorrect.

The output i generated from SQL for query 4 is:
InnerJoinTest1_PK InnerJoinTest2_PK
1 2
1 3
2 3
1 4
2 4
3 4
1 5
2 5
3 5
4 5

Output for query 5 is:
InnerJoinTest1_PK InnerJoinTest2_PK
1 1
1 2
2 2
1 3
2 3
3 3
1 4
2 4
3 4
4 4
1 5
2 5
3 5
4 5
5 5
Post #529812
Posted Tuesday, July 08, 2008 2:31 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, June 19, 2012 12:30 AM
Points: 712, Visits: 930
Good article but the typos/spellings were a little annoying.
Post #529821
Posted Tuesday, July 08, 2008 4:27 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 02, 2013 12:15 PM
Points: 1,443, Visits: 711
Good article, but it would have been good to proofread it for grammer and typos...
Post #529869
Posted Tuesday, July 08, 2008 4:44 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 11:50 AM
Points: 4,914, Visits: 8,652
The concepts involved are really basic, so basic that I wouldn't even understand why sitting at your desk typing queries without perfect knowledge of these concepts.


--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #529884
Posted Tuesday, July 08, 2008 4:45 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, January 14, 2013 4:54 AM
Points: 836, Visits: 72
Hi, it was a very good article.
Thanks,
Sreeju
Post #529885
Posted Tuesday, July 08, 2008 4:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 08, 2008 9:56 AM
Points: 1, Visits: 8
Helpful article. But dear Zeus, the spelling and english are terrible...
Post #529889
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse