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