[1] : The Free On-line Dictionary of Computing (27 SEP 03)

outer join
     
         a less commonly used variant of the inner join
        relational database operation.  an inner join selects rows
        from two tables such that the value in one column of the
        first table also appears in a certain column of the second
        table.  for an outer join, the result also includes all rows
        from the first operand "left outer join", "=", or the
        second operand "right outer join", "=", or both "full
        outer join", "=".  a field in a result row will be null if
        the corresponding input table did not contain a matching row.
     
        for example, if we want to list all employees and their
        employee number, but not all employees have a number, then we
        could say in sql:
     
        	select employee.name, empnum.number
        	where employee.id = empnum.id
     
        the "=" means "left outer join" and means that all rows from
        the "employee" table will appear in the result, even if there
        is no match for their id in the empnum table.
     
        2001-03-23
     
     
see also:
inner join relational database tables column sql 

Join >> J Words
Join, definition of term: Join
join_pag1.html