[Discuss] [OT RTFM]Quick SQL quesiton

[markw at mohawksoft.com (markw at mohawksoft.com)]

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
> <tmcallaghan at 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 at blu.org
> http://lists.blu.org/mailman/listinfo/discuss
>