I've got absolutely no idea what you mean. Please will you supply table DDL in the form of CREATE TABLE statements, sample data in the form of INSERT statements, and expected results.

Thanks

John