Statements (14)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
SQL standard feature
|
| gptkbp:enables |
FULL OUTER JOIN
LEFT OUTER JOIN RIGHT OUTER JOIN |
| gptkbp:hasSyntax |
SELECT * FROM A LEFT OUTER JOIN B ON A.id = B.id
|
| https://www.w3.org/2000/01/rdf-schema#label |
SQL-92 Outer Joins
|
| gptkbp:introducedIn |
gptkb:SQL-92
|
| gptkbp:partOf |
gptkb:SQL-92
|
| gptkbp:purpose |
return unmatched rows from one or both tables in a join
|
| gptkbp:replacedBy |
proprietary outer join syntax
|
| gptkbp:standardizedBy |
gptkb:ANSI
|
| gptkbp:usedIn |
relational databases
|
| gptkbp:bfsParent |
gptkb:SQL-92
|
| gptkbp:bfsLayer |
7
|