Detailed example of outer joins
Wednesday, February 23, 2011
2:41 PM
grunt> out = JOIN names by species LEFT, actions by species;    
grunt> DUMP out; 
… Success!!
(Bill,Cat,Cat,purrs)
(Bill,Cat,Cat,scratches)
(Morris,Cat,Cat,purrs)
(Morris,Cat,Cat,scratches)
(Ed,Horse,Horse,neighs)
(Tux,Penguin,,)
grunt> out = JOIN names by species RIGHT, actions by species; 
grunt> DUMP out;                                              
... Success!!
(Bill,Cat,Cat,purrs)
(Bill,Cat,Cat,scratches)
(Morris,Cat,Cat,purrs)
(Morris,Cat,Cat,scratches)
(,,Dog,barks)
(Ed,Horse,Horse,neighs)
grunt> out = JOIN names by species FULL, actions by species;  
grunt> DUMP out; 
... Success!!
(Bill,Cat,Cat,purrs)
(Bill,Cat,Cat,scratches)
(Morris,Cat,Cat,purrs)
(Morris,Cat,Cat,scratches)
(,,Dog,barks)
(Ed,Horse,Horse,neighs)
(Tux,Penguin,,)
grunt> 