| Subject | English | German |
| comp., MS | full outer join | vollständige äußere Verknüpfung, vollständiger äußerer Join (A type of outer join in which all rows in all joined tables are included, whether they are matched or not. For example, a full outer join between titles and publishers shows all titles and all publishers, even those that have no match) |
| comp., MS | left outer join | linke äußere Verknüpfung (A type of outer join in which all rows from the left-most table in the JOIN clause are included. When rows in the left table are not matched by rows in the right table, all result set columns that come from the right table are assigned a value of NULL) |
| comp., MS | right outer join | rechte äußere Verknüpfung (An outer join in which all the records from the right side of the RIGHT JOIN operation in the query's SQL statement are added to the query's results, even if there are no matching values in the joined field from the table on the left) |