Here is my problem. As good as your description of the process, I can't see what you are trying to accomplish. You should post the DDL for the tables, some sample data for the tables (NOT PRODUCTION DATA), and the expected results when done based on the sample data.