Database Software

Is there anyway of getting owb to implement the following sql without
resorting to using a insert update operation:

insert into desttable
(select * from myview where not exists (select null from b where desttable.emp_id=myview.emp_id)

This sounds almost like the perfect application for an insert/update (or merge)
operation. But in my case, I do not want to update the destination tables if I get
a match, I am only interested in using the insert part of a merge operation. I could
create a dummy update clause, but that would be a waste of resources.

Any ideas?


Graeme