Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Databases General > Re: rewriting L...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 5 of 6 Topic 3144 of 3283
Post > Topic >>

Re: rewriting LEFT JOINs as RIGHT JOINs

by "Roy Hann" <specially@[EMAIL PROTECTED] > Apr 25, 2008 at 06:03 AM

"David Cressey" <cressey73@[EMAIL PROTECTED]
> wrote in message 
news:1o_Pj.5998$WU.905@[EMAIL PROTECTED]
>
>> > as you say, it is not merely changing the LEFT to a RIGHT, you are
>> > changing the entire SQL query.  This can cause unforeseen problems,
> [...]
>> > are actually returned.
>>
>> Total nonsense.
>
> How about making some sense out of it, Roy?
>
> Here my two cents:
> It's not clear to me that the OP understands that  A LEFT JOIN B is
> equivalent to B RIGHT JOIN A...  But if the OP does understand that, 
then
> obviously (s)he means more than just changing  every LEFT JOIN to a
RIGHT
> JOIN.

On the contrary, I think the OP understood it completely, and (s)he didn't

mean more than that.  It was the half-wit responder I was slamming.

Roy
 




 6 Posts in Topic:
rewriting LEFT JOINs as RIGHT JOINs
yawnmoth <terra1024@[E  2008-04-19 07:10:48 
Re: rewriting LEFT JOINs as RIGHT JOINs
Harry Skelton <skelton  2008-04-19 12:03:50 
Re: rewriting LEFT JOINs as RIGHT JOINs
"Roy Hann" <  2008-04-24 12:02:39 
Re: rewriting LEFT JOINs as RIGHT JOINs
"David Cressey"  2008-04-24 11:43:57 
Re: rewriting LEFT JOINs as RIGHT JOINs
"Roy Hann" <  2008-04-25 06:03:54 
Re: rewriting LEFT JOINs as RIGHT JOINs
--CELKO-- <jcelko212@[  2008-04-22 13:13:15 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 15:23:17 CST 2008.