Dnia 2004-02-03 07:28, Użytkownik Russell Shaw napisał:
> Hi,
> I'm using postgresql 7.3.4 on debian. I get bad results
> from a two-table left outer join.
>
> First table: select * from descriptions;
>
> desc_id | description
> ---------+-------------
> 909097 | cap
> 107890 | resis
> 223940 | ic
> 447652 | electro
> (4 rows)
>
>
> Second table: select * from parts;
>
> part_id | desc_id | mounting | man_id
> ---------+---------+----------+--------
> 2 | 107890 | SMD | 7
> 1 | 909097 | LEADED | 1
> 3 | 223940 | LEADED | 8
> (3 rows)
>
>
> Join:
> SELECT parts.*, d.description, d.desc_id FROM parts p LEFT OUTER JOIN
^^^^^^^^^^^^^^^
You can't access "parts" here - you used table alias, so the only way to
access it is using "p.*"
> descriptions d ON p.desc_id=d.desc_id;
>
> NOTICE: Adding missing FROM-clause entry for table "parts"
Rewrite your query and show your results.
Regards,
Tomasz Myrta
