|
Assuming that we want to return all numbers, even if the german translation is missing, we need an outer join. An outer join uses a (+) on the side of the operator (which in this case happens to be the equality operator) where we want to have nulls returned if no value matches:
|
www.adp-gmbh.ch/ora/sql/outer_join.html
www.adp-gmbh.ch/ora/sql/outer_join.html
|
|
|
|
OUTER JOIN in SQL allows us to retrieve all values in a certain table regardless of whether these values are present in other tables. ... The syntax for performing an outer join in SQL is database-dependent. For example, in Oracle, we will place an "(+)" in the WHERE clause on the other side of the table for which we want...
|
www.1keydata.com/sql/sqlouterjoin.html
www.1keydata.com/sql/sqlouterjoin.html
|
|
|
|
However, I also think that the missing feature of FULL OUTER JOIN is a real drawback to MySQL. but from MySQL 4 on you can use a workaround using the UNION. for example if you take the left and right joins examples above and do a UNION on the 2 select statements you will get a FULL JOIN.
|
www.wellho.net/mouth/158_MySQL-LEFT-JOIN-and-RIGHT-JOIN...
www.wellho.net/mouth/158_MySQL-LEFT-JOIN-and-RIGHT-JOIN-INNER-JOIN-and-OUTER-JOIN.html
|
|
|
In this first of two parts, Terry Purcell, an IBM Gold Consultant with Yevich, Lawson, and Associates, and the the winner of the Best Overall Speaker Award at the 2001 IDUG Asia Pacific conference in Canberra, Australia, offers advice on coding predicates in outer joins. ... Outer join classification...
|
www.ibm.com/developerworks/db2/library/techarticle/purc...
www.ibm.com/developerworks/db2/library/techarticle/purcell/0112purcell.html
|
|
Learn how to use the new ANSI-compliant join syntax in Oracle 9i, which simplifies the task of performing a full outer join. ... An outer join extends the result of an inner join by including rows from one table (say Table A) that don't have corresponding rows in another table (say Table B). An important thing to note here...
|
www.oreillynet.com/pub/a/network/2002/04/23/fulljoin.ht...
www.oreillynet.com/pub/a/network/2002/04/23/fulljoin.html
|
|
What's the difference between an inner join and an outer join? When you wish to get data from two related tables, you can use an inner join or an outer join to define how... ... When you wish to get data from two related tables, you can use an inner join or an outer join to define how the data is related.
|
www.answerbag.com/q_view/1433
|
|
OBE Home > Database 10g > Single Instance > BIDW > Outer Join ... Using Partitioned Outer Join to Fill Gaps in Sparse Data ... To overcome the problem of sparsity, you can use a partitioned outer join to fill the gaps in a time series. Such a join extends the conventional outer join syntax by applying the outer join to...
|
www.oracle.com/technology/obe/obe10gdb/bidw/outerjoin/o...
www.oracle.com/technology/obe/obe10gdb/bidw/outerjoin/outerjoin.htm
|
|
This post assumes you’ve read the previous posts in this series. ... I’ll cover Left and Right Outer Join in this post and hopefully put up an additional post for Full Outer Join next week.
|
blogs.msdn.com/vbteam/archive/2008/01/31/converting-sql...
blogs.msdn.com/vbteam/archive/2008/01/31/converting-sql-to-linq-part-8-left-right-outer-join-bill-horst.aspx
|
|
A full outer join combines the results of both left and right outer joins. The joined table will contain all records from both tables, and fill in NULLs for missing matches on either side.
|
www.codeproject.com/KB/cs/TwoDataTablesOuterJoin.aspx
www.codeproject.com/KB/cs/TwoDataTablesOuterJoin.aspx
|
|
