Problems with a Query between 7.3 and 8.2

Hi,

I have to migrate an existing System from PostgreSQL 7 and 8.2.
There is a query that I'm not fully understand. It is running with
7.3.21 generating two notices about missing FROM's:

select poid,prodort.bez1 as prodort,sum(anz) as anz,
art,bez1 from best_dat where type='P' and relid=best_hdr.relid
and best_hdr.prod_date='20.04.2008' and poid=prodort.id
group by poid,prodort.bez1,art,bez1
order by poid,prodort.bez1,poid,art,bez1;

NOTICE:  Adding missing FROM-clause entry for table "prodort"
NOTICE:  Adding missing FROM-clause entry for table "best_hdr"poid |       prodort        | anz | art |
bez1

------+----------------------+-----+-----+----------------------------------   1 | VK-Kueche            |   5 |  50 |
Malzkaffee                        1 | VK-Kueche            |  30 |  57 | Kakao                              1 |
VK-Kueche           |  18 |  58 | Milch warm                 ...
 


The tables are as follows:
                          Table "public.prodort"Column |     Type      |                     Modifiers

--------+---------------+----------------------------------------------------id     | integer       | not null default
nextval('"prodort_id_seq"'::text)bez1   | character(20) | code   | character(3)  | 
Indexes: prodort_id_key unique btree (id)
      Table "public.best_dat"Column  |     Type      | Modifiers 
---------+---------------+-----------relid   | integer       | not nulltype    | character(1)  | bpid    | integer
| not nullbpcode  | character(3)  | poid    | integer       | grpid   | integer       | not nullart     | integer
|bez1    | character(32) | anz     | integer       | portion | character(1)  | fp      | integer       | default
0wertig | integer       | default 1
 
Indexes: best_dat_rt btree (relid, "type")


PGSQL 8.2.6 bumps out with the following:

# select poid,prodort.bez1 as prodort,sum(anz) as anz,
# art,bez1 from best_dat where type='P' and relid=best_hdr.relid
# and best_hdr.prod_date='20.04.2008' and poid=prodort.id
# group by poid,prodort.bez1,art,bez1
# order by poid,prodort.bez1,poid,art,bez1;
ERROR:  missing FROM-clause entry for table "prodort"
LINE 1: select poid,prodort.bez1 as prodort,sum(anz) as anz,                   ^
t seems, that PGSQL is missing the From Clause for bez1 but there
is a prodort.bez1 in the query...?

How do I wirte this correctly?

THX,

Holm
--      Technik Service u. Handel Tiffe, www.tsht.de, Holm Tiffe,     Freiberger Straße 42, 09600 Oberschöna, USt-Id:
DE253710583www.tsht.de, info@tsht.de, Fax +49 3731 74200, Mobil: 0172 8790 741