| Subject | Spanish | English |
| comp., MS | combinación externa | outer join (A join that includes all the rows from the joined tables that meet the search conditions, even rows from one table for which there is no matching row in the other join table) |
| comp., MS | combinación externa completa | full outer 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 | combinación externa derecha | right outer join (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) |
| comp., MS | combinación externa izquierda | left outer join (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) |