Re: [SQL] selective updates

2005-12-15 Thread Gianluca Riccardi
Gianluca Riccardi wrote: [cut] solved, i used a function giving as result the wanted value from table2.column1 in a UPDATE table1 SET column4=(my_personal_func()) WHERE 'cirteria on table1.column2 table2.column2' ; sorry for making you wasting your time Gianluca Riccardi ---

[SQL] selective updates

2005-12-15 Thread Gianluca Riccardi
sorry for posting a new opening 'thread', but my subscribing to the ml is later than a post with the subject 'APPEND INTO?' dated Thu, 01 Dec 2005 10:32:08 -0500 so i can't make reply to that. follows a copy of that post Mark Fenbers writes: I want to SELECT INTO mytable WHERE (criteria are m