Give us the defintiion of the tables, as well as the data in the source tables.

Create another result table which will contain the result set that you need based on the source data.

Using that, we can help you build the code you need to get the result.