|
|
PostgreSQL OpenSource Database
|
2.3 SELECT examples
| ← 2.2 Alter Table | [ up ] - [ TOC ] - [ A - Z ] | 2.4 Data Types → |
LEFT OUTER JOIN
First, an inner join is performed. Then, for each row in T1 that does not satisfy the join condition with any row in T2, a joined row is added with null values in columns of T2. Thus, the joined table unconditionally has at least one row for each row in T1.SELECT id, lang, name, construval
FROM items LEFT OUTER JOIN vconstruval
ON id=item_id AND lang=item_lang having lang='de'
AND id NOT IN (SELECT item_id FROM items_attributes WHERE attr_id=5002)
ORDER BY name, construval;