[Discuss] [OT RTFM]Quick SQL quesiton

[David Kramer]

I recently found this page, which explains SQL joins better than I've
ever seen done before, using elementary set theory.

http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html


On 10/04/2013 01:33 PM, markw at mohawksoft.com wrote:
> 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
>>
>
> _______________________________________________
> Discuss mailing list
> Discuss at blu.org
> http://lists.blu.org/mailman/listinfo/discuss