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
