tag:blogger.com,1999:blog-6944050187568241059.post7146872919632785811..comments2024-03-13T22:24:49.135-07:00Comments on Thoughts From A Management Platform Developer: Idiot Lesson On The Types Of SQL JOINsJohn Mazzhttp://www.blogger.com/profile/11415685873835789040noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6944050187568241059.post-83107190492818927362010-09-23T11:46:58.111-07:002010-09-23T11:46:58.111-07:00You share my affliction -- you're too hard on ...You share my affliction -- you're too hard on yourself. <br /><br />Excellent post, and right when I needed it! Thanks,Brycehttps://www.blogger.com/profile/05545690594791865494noreply@blogger.comtag:blogger.com,1999:blog-6944050187568241059.post-90603522133458135172010-01-29T09:30:54.585-08:002010-01-29T09:30:54.585-08:00...and a full (outer) join is the union of both ci......and a full (outer) join is the union of both circles. thus inner, left, right, and full joins will at most give you N+M rows - the total amount of data inside both circles.<br /><br /> the venn diagram analogy breaks down for the cross join, however, which gives you up to NxM rows. the lay analogy i use for cross joins is an excel spreadsheet where each table becomes one of the (vertical or horizontal) axes. adding where conditions then starts to "blank-out" certain cells that don't match those conditions...and the rest are returned.Anonymousnoreply@blogger.com