I have been doing SQL for a *long* time, but I don't do it consistently enough to know the esoterica off the top of my head.
There is a left join, a right join, and a full join. A full join returns null for empty elements from both sides. The left and right joins do what you'd expect. > On Fri, Oct 4, 2013 at 12:25 PM, Tim Callaghan > <tmcallag...@gmail.com>wrote: > >> > but, inner joins only produce matching records, and outer joins only >> give >> > the compete set of records from one table or the other, not both. >> > > FULL OUTER JOIN? > > Gordon > _______________________________________________ > Discuss mailing list > Discuss@blu.org > http://lists.blu.org/mailman/listinfo/discuss > _______________________________________________ Discuss mailing list Discuss@blu.org http://lists.blu.org/mailman/listinfo/discuss
