>> Somebody else probably has a more clever way to do it though......
>I would do this unconditionally.
>UPDATE ... FROM ... WHERE EXISTS (SELECT ...)
>INSERT INTO ... WHERE NOT EXISTS (SELECT ...)
>That are still 2 queries, but better than playing around with triggers.
I need to do this in a trigger, though. The trigger I need to create
is one that will run when I try to update a view. I'm going to need to
update a different table, instead.
thnx,
Chris