Hi, On Wed, Dec 22, 2004 at 09:41:40AM +0000, Richard Huxton wrote: > UNION etc doesn't necessarily mean you can't update, so long as the > underlying table/key can be identified.
I think you mean UNION ALL, i.e. the set addition, don't you? Otherwise UNION (wothout ALL) is kind of a aggregation due to it only adds a row once to the resulting set wheter it is found twice or not. Therefore any updates are not possible. Regards, Yann ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]