I cant figure out the joins and groupby's

We have two staging tables (Parent and Child) that contain both insert and update information. The Childs parent my be in either the Production or the Staging table.

I need to display a DISTINCT organization name and record number from the combination of the records in Parent and the Child (just one entry per organization). If there is more than one Child, or more than one parent update, just display the parent information once.

a little more info

The staging tables are used to review information entered by the users before posting to the production tables. There are two staging tables – Master and Child. The Master and the Child tables can have both New records or Updated records. To enter a Child record you need to have a Master, either in the Staging or Prod tables.

So I have a mixture of records in the Staging tables. I need to build a list which has an organ name, record number from either the Prod Master (Update in Stage Master) or Stage Master (Insert)

There can only be one entry in the list for each different organization whether it be in the Master (existing) or in the Stage (new).

The organization can be new or existing, there can be updates/inserts to the Prod master from the Stage master and updates/inserts to the Prod child form the stage child.

The problem is who do I look at first (I assume the Stage Master) and how do I join the Prod Master, Stage Master and Stage Child together to produce a single reference to a Master (whether it be Prod or Stage).

Hope this helps explain my situation…..it is pretty confusing to my…….

Thanks dan

Why do you join product and staging? Doesn't that kind of defeat the purpose of staging?