To really help we need some additional information. It would help if you could post the DDL (CREATE TABLE statement(s)) for the table(s) involved, some sample data (not production data) for each table involved (as INSERT INTO statements), and the expected results of the query.

For help with this, please read the first article I reference below in my signature block regarding asking for help.

Just from your two posts I am really not sure what you are trying to accomplish.