Reg: Join Conditions for Tables to create a View for Generic Extraction

Hi Experts,

Am trying to extract the data from Solman, for this purpose am creating a Generic Extractor based on three tables. So, can anyone please help me out by providing the join conditions to create a view based upon the following three tables,

1. CRM_ORDERM_H

2. DNOD_NOTIF

3. DNOD_NOTIF_S

Anyways i require the following fields in the extractor finally:

CRM CHANGED AT

GUID

SAP COMPONENT

RELEASE

REPORTED BY

These are the some of the major fields that i require in the final extractior. Please help me out ASAP with the table join conditions..

Will Assign Points for the helpfull answer...

Thanks,

Gattu.