Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Discuss] [OT RTFM]Quick SQL quesiton

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>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.
> Gordon
> _______________________________________________
> Discuss mailing list
> Discuss at

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /