"Peter Exner" <[EMAIL PROTECTED]> writes:
> SQL-Statement:
> UPDATE table1 SET value1 = value1 - (SELECT value1_sum FROM tmp_table WHERE
> table1.table1_id = tmp_table.max_id) WHERE split_anteil < 10000 AND afa_ende
> = 24061 AND table1.table1_id = tmp_table.max_id;
That's not standard SQL. You can fix it to work under 8.1 the same as
it did before by adding "FROM tmp_table", or if you are stubborn you can
turn add_missing_from on ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
