<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Paul White
»
The Right Kind Of Join II
20 posts, Page 2 of 2
««
1
2
The Right Kind Of Join II
Rate Topic
Display Mode
Topic Options
Author
Message
rfr.ferrari
rfr.ferrari
Posted Thursday, September 01, 2011 5:15 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:51 AM
Points: 1,219,
Visits: 13,507
thanks Paul!!!
Really, this question is very interesting!!
today , I learned anything!!!!
rfr.ferrari
DBA
- SQL Server
2008
MCITP | MCTS
remember is live or suffer twice!
Post #1168585
Britt Cluff
Britt Cluff
Posted Thursday, September 01, 2011 5:48 AM
SSCommitted
Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,558,
Visits: 247
Good question, I learned something new today.
http://brittcluff.blogspot.com/
Post #1168601
Cliff Jones
Cliff Jones
Posted Thursday, September 01, 2011 7:37 AM
Hall of Fame
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:11 PM
Points: 3,390,
Visits: 3,403
Very interesting question, thanks Paul.
Post #1168657
Daniel Bowlin
Daniel Bowlin
Posted Thursday, September 01, 2011 7:59 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 11:53 AM
Points: 2,672,
Visits: 2,416
paul.knibbs (9/1/2011)
This is one of those questions where the common sense answer (e.g. both tables have no data in, so of course the answer will be zero rows!) is actually right...I knew nothing about the stuff explained in the answer, so I learned something today.
Me too. Good question and answer, thanks.
Post #1168677
OzYbOi d(-_-)b
OzYbOi d(-_-)b
Posted Thursday, September 01, 2011 8:38 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176,
Visits: 778
Thanks Kiwi! Look forward to the next installment.
Post #1168713
FargoUT
FargoUT
Posted Thursday, September 01, 2011 11:15 AM
Old Hand
Group: General Forum Members
Last Login: Tuesday, October 11, 2011 1:51 PM
Points: 341,
Visits: 311
Got it wrong. That's what I get for not really reading it. I just thought it was a duplicate question. Whoops.
Post #1168810
skrilla99
skrilla99
Posted Thursday, September 01, 2011 11:36 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 10, 2013 2:50 PM
Points: 1,117,
Visits: 1,134
Good question, great explanation.
Thanks!
Post #1168823
KWymore
KWymore
Posted Thursday, September 01, 2011 11:52 AM
SSCrazy
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:58 AM
Points: 2,570,
Visits: 1,530
Nice question. Very interesting explanation. Looking forward to question 3!
Post #1168833
L' Eomot Inversé
L' Eomot Inversé
Posted Thursday, September 01, 2011 1:52 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 6:35 AM
Points: 7,078,
Visits: 7,119
SQLkiwi (9/1/2011)
Hi Tom,
The third question in this series will be published next week (8 September).
I promise your question will be answered then.
Paul
I'll look forward to it.
As someone with a bit of experience of language design (including functional and relational DMLs) I'm intrigued by what appears to have happened here.
Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #1168902
Koen Verbeeck
Koen Verbeeck
Posted Sunday, September 04, 2011 11:43 PM
SSCrazy Eights
Group: General Forum Members
Last Login: 2 days ago @ 6:54 AM
Points: 9,364,
Visits: 6,462
Interesting question, thanks.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1169838
« Prev Topic
|
Next Topic »
20 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
