Understanding INNER join in detail

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Susantha Bathige » Understanding INNER join in detail

135 posts, Page 1 of 14

1 2 3 4 5 »»»

Understanding INNER join in detail

Rate Topic

Display Mode

Topic Options

Author

Message

Susantha Bathige

Posted Monday, July 07, 2008 10:20 PM

Valued Member

Group: General Forum Members
Last Login: Monday, May 27, 2013 5:53 AM
Points: 52, Visits: 256

Comments posted to this topic are about the item Understanding INNER join in detail

Susantha

Post #529749

m.shivaleela

Posted Tuesday, July 08, 2008 12:53 AM

Mr 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

monique.steijnen

Posted Tuesday, July 08, 2008 1:26 AM

Forum 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?? w00t

Post #529796

bagofbirds-767347

Posted Tuesday, July 08, 2008 1:31 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, April 11, 2013 1:03 PM
Points: 56, Visits: 201

whoa. dude really needs an editor.

Post #529799

hiyajac

Posted Tuesday, July 08, 2008 1:53 AM

Forum 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

rosh-396756

Posted Tuesday, July 08, 2008 2:31 AM

Say 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

SuperDBA-207096

Posted Tuesday, July 08, 2008 4:27 AM

UDP 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

spaghettidba

Posted Tuesday, July 08, 2008 4:44 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:43 AM
Points: 4,804, Visits: 8,091

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.

Get your two-cent-answer quickly
The Spaghetti DBA

Post #529884