Not enough to work with here. If you could post the DDL (CREATE TABE statement) for the two tables, some sample data for the tables (INSERT INTO statements), and the expected results based on the sample data I am sure we can help you with your query.

If you need some help with the above information, please read the first article I have referenced below in my signature block. It will walk you through what you should post and how to post it to get the best possible answers.