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 6 of 6 Topic 3144 of 3270
Post > Topic >>

Re: rewriting LEFT JOINs as RIGHT JOINs

by --CELKO-- <jcelko212@[EMAIL PROTECTED] > Apr 22, 2008 at 01:13 PM

>> can every LEFT JOIN be rewritten as a query with RIGHT JOINs? <<

Sure.  Just put the preserved table expression on the RIGHT or LEFT
side of the infixed join operator and leave the ON clause alone.  But
since you come from a culture that reads left to right, RIGHT OUTER
JOIN is harder to maintain or to even read.
 




 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 Mon Oct 13 7:02:50 CDT 2008.