Hello, the following used to work:
create table t1(t1f1 text, t1f2 text, t1f3 text); create table t2(t2f2 text, t2f3 text); insert ... update t1 set t1f1='test' where t1.t1f2=t2.t2f2 and t1.t1f3=t2.t2f3; unfortunately, now I get the error that t2 is not in the FROM clause. I know I can do update t1 set t1f1='test' where t1.t1f2||'/'||t1.t1f3 in (select t2.t2f2||'/'||t2.t2f3 from t2); But I'm afraid that's very expensive. Do you have a suggestion for alternative syntax for my initial query? Thank you, Oliver Seidel ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
