# Outer

The explicit Join prefix can be preceded by the prefix outer in order to specify an outer join. In an outer join all combinations between the two tables are generated. The resulting table will thus contain combinations of field values from the raw data tables where the linking field values are represented in one or both tables.

The outer keyword is optional and is the default join type used when a join prefix is not specified.

Syntax:

Outer Join [ (tablename) ](loadstatement |selectstatement )

Arguments:

Table load arguments

| Argument | Description |
| --- | --- |
| tablename | The named table to be compared to the loaded table. |
| loadstatement or selectstatement | The LOAD or SELECT statement for the loaded table. |

Example:

Example 1A

| Table1 | - |
| --- | --- |
| A | B |
| 1 | aa |
| 2 | cc |
| 3 | ee |

Example 1B

| Table2 | - |
| --- | --- |
| A | C |
| 1 | xx |
| 4 | yy |

`SQL SELECT  * 
 from table1;` `join SQL SELECT 
* from table2;`

OR

`SQL SELECT * 
 from table1;` `outer join 
 SQL SELECT * from table2;`

Example 1C

| Joined table | - | - |
| --- | --- | --- |
| A | B | C |
| 1 | aa | xx |
| 2 | cc | - |
| 3 | ee | - |
| 4 | - | yy |

## Learn more

* [Join](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/Join.htm)
* [Inner](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/Inner.htm)
* [Left](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/Left.htm)