insert as select on mutating table

[sukimac]

Hi All,

We are trying to populate one table as an insert as a select from several other tables including the table that we are inserting into. It works when there are already records in the table but not on the initial insert (b/c on the conditional operator on the inserting table). Any suggestions?