Re: Learning SQL?

[Norman Palardy <palardyn at shaw dot ca>]

On May 9, 2004, at 9:33 PM, Kevin Ballard wrote:

> Hrm. The documentation I saw called that simple a LEFT JOIN and it 
> used the syntax
> SELECT salesrepname, totalsales FROM SalesReps LEFT JOIN Sales ON 
> SalesReps.salesrepID = Sales.salesrepID;
> It had a similar RIGHT JOIN and never mentioned OUTER JOIN. What 
> you're saying is a LEFT or RIGHT JOIN is really an OUTER JOIN without 
> the OUTER keyword written?
The first one is a simple join and only gives results where there are 
matching rows in both tables.
A full out join will give a row for EACH row in both tables and have 
NULLS for values in the "other" columns that would have been present 
from the table that does not have a match
And yes. OUTER and INNER are optional 

_______________________________________________
Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>