Joins
От | Russell Shaw |
---|---|
Тема | Joins |
Дата | |
Msg-id | 401E70E1.2020100@iprimus.com.au обсуждение исходный текст |
Ответы |
Re: Joins
|
Список | pgsql-novice |
Hi, I'm trying to get a list of all the rows in the Parts table, with the integer indexes of man_id, case_id, and desc_id, replaced with text from their respective tables. In the Parts table, any of man_id, case_id, and desc_id may be absent: Table1, Parts: part man_id case_id desc_id ------------------------------ text int int int Table2: Manufacturers: man_id manufacturer -------------------- int text Table3, Cases: case_id case ------------- int text Table4, Descriptions: desc_id description -------------------- int text Is this right? : SELECT part, manufacturer, case, description FROM parts LEFT OUTER JOIN manufacturers, cases, descriptions NATURAL
В списке pgsql-novice по дате отправления: