The Daily Static
  The Daily Static
UF Archives
Register
UF Membership
Ad Free Site
Postcards
Community
Geekfinder
UFie Gear
Advertise on UF
Forum Rules
& FAQ

Username

Password


Create a New Account

  
 

Back to UserFriendly Strip Comments Index
Inner Join vs Left Join by dennismv2014-05-05 09:54:59
  I'm confused by rebill 2014-05-05 13:11:48
How is
and 'tacks on' matching keys from the right table, leaving left table rows without matching keys as is."

not touching upon the difference?.

I would have said it a little differently, maybe something like, "but does not throw away records in the left table that don't match anything in the right table. Those are returned, too, but with NULL values in place of all of the right table columns."

[ Reply ]
    I think my concern was .. by dennismv2014-05-05 13:32:06
      That's from experience by rebill2014-05-05 19:22:36
      So *just* the difference? by oot2014-05-05 20:46:47
        ^ laik (n/t) by dennismv2014-05-06 12:41:22

 

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)