Understanding INNER join in detail

Question

Post reply

Understanding INNER join in detail

Susantha Bathige

Ten Centuries

Points: 1040
More actions
July 7, 2008 at 10:20 pm

#194827

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

Viewing 15 posts - 1 through 15 (of 134 total)

You must be logged in to reply to this topic. Login to reply

m.shivaleela Mr or Mrs. 500 Points: 515 More actions · Answer 1

Good Article and it really gives you a clear picture of Inner join..

Good One....

🙂

monique.steijnen Newbie Points: 9 More actions · Answer 2

The result of Q4 & 5 confuses me. Why is the combination of 5--5 not included and aren't the keys switched??:w00t:

bagofbirds-767347 Ten Centuries Points: 1110 More actions · Answer 3

bagofbirds-767347

Ten Centuries

Points: 1110

July 8, 2008 at 1:31 am

#839296

whoa. dude really needs an editor.

hiyajac Grasshopper Points: 13 More actions · Answer 4

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

rosh-396756 SSCrazy Points: 2338 More actions · Answer 5

Good article but the typos/spellings were a little annoying.

SuperDBA-207096 SSCrazy Eights Points: 8176 More actions · Answer 6

Good article, but it would have been good to proofread it for grammer and typos...

spaghettidba SSC Guru Points: 105732 More actions · Answer 7

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

SQL Joker Ten Centuries Points: 1256 More actions · Answer 8

SQL Joker

Ten Centuries

Points: 1256

July 8, 2008 at 4:45 am

#839362

Hi, it was a very good article.

Thanks,

Sreeju

Emanuele Ciriachi Grasshopper Points: 11 More actions · Answer 9

Helpful article. But dear Zeus, the spelling and english are terrible...

Earl Grasshopper Points: 11 More actions · Answer 10

As high school teachers have been known to mark on papers that fail, "if English is not your native language, please see me ..."

John Bowman-237558 SSC Veteran Points: 236 More actions · Answer 11

I found it very difficult to learn from this article due to the poor grammer/english. It should've been edited before release.

jvijaykarthik Grasshopper Points: 23 More actions · Answer 12

hatsoff for your efforts..

good article for beginners..

experts comments are void..

SRDEV SSC Enthusiast Points: 101 More actions · Answer 13

This article should not have been published with the quality of the writing. This takes away from the value of this site.

Former Member Grasshopper Points: 21 More actions · Answer 14

:DOnce past the grammatics, the article is at best basic skill set and not worth the time to log in and read. Don't give up, English is a difficult language to master.