I have a somewhat challenging SQL insert I need to accomplish in Oracle. The schema set up is not mine and it is a little weird. Here's a schema break down:<BR><BR>Table: agent<BR>agnt_id ...