UserFriendly Strip Comments


	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 dennismv	2014-05-05 09:54:59
I'm confused	by rebill	2014-05-05 13:11:48
I think my concern was ..	by dennismv	2014-05-05 13:32:06
That's from experience	by rebill	2014-05-05 19:22:36
I have been asked that question a few times, and it has always been by someone that did not grok "join". To describe the difference: "you also get back the records that don't match anything in the second table, with the second table's column values each filled in with null." Giving an answer like that will almost always lead into the question of what an inner join is, so it is just inefficient to hold back the two parts.
[ Reply ]

[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.)