You Should Never Use IN In SQL To JOIN With Another Table

home
database
view story

16 Kicks

You Should Never Use IN In SQL To JOIN With Another Table(sqlservercode.blogspot.com)

submitted by SQL_Menace(4890) 4 years, 9 months ago

Do you use the following syntax? SELECT * FROM TABLE WHERE CoLumn IN (SELECT CoLumn FROM TABLE) Do NOT use that it can cause big problems if you do not understand exactly how IN and NOT IN works

2 comments |category: Database |Views: 9
Tweet

tags: in Join Database SQL another

Everyones tags:

Your Tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

jeremyholland(0) -

Glohamar(0) -

motionblur(0) -

spirit1(3160)

More who kicked this story...

Comments:

posted by mghaoui(340) 4 years, 9 months ago 0

It's good articles like this that set DotNetKicks apart from the rest. Keep em coming!

posted by edburdo(1350) 4 years, 9 months ago 0

Go read many of the comments on the article. You'll find lots of conflicting theories as to the benefits of "never use IN, it's EVIL!"

Most Active Users

What's this?