title: Oracle 11g - Join data from multiple rows with m to n relation table
body: <p>I have maybe simple problem but I still can't figure out how make things working. </p>
  
  <p>I have three tables with these important fields: </p>
  
  <ol>
  <li><strong>Rule</strong> - RuleOID</li>
  <li><strong>RuleToModificationReason</strong> - RuleOID, MdfnReasonOID</li>
  <li><strong>ModificationReason</strong> - MdfnReasonOID, MdfnTyp (CREATION or DELETION), MdfnDetail</li>
  </ol>
  
  <p>And f.e. I have this data: </p>
  
  <ol>
  <li><strong>Rule</strong> - RuleOID = 1</li>
  <li><strong>RuleToModificationReason</strong> 
  <ul>
  <li>RuleOID = 1, MdfnReasonOID = 1</li>
  <li>RuleOID = 1, MdfnReasonOID = 2</li>
  </ul></li>
  <li><strong>ModificationReason</strong> 
  <ul>
  <li>MdfnReasonOID = 1, MdfnTyp = 'CREATION', MdfnDetail = 'Creation detail'</li>
  <li>MdfnReasonOID = 2, MdfnTyp = 'DELETION', MdfnDetail = 'Deletion detail'</li>
  </ul></li>
  </ol>
  
  <p>I want to have output on one row for creation and deletion with rule oid. </p>
  
  <p>f.e. : RuleOID, Creation detail, Deletion detail.</p>
  
  <p>I am able to load it in two rows like: </p>
  
  <ol>
  <li>RuleOID, Creation detail, NULL</li>
  <li>RuleOID, NULL , Deletion detail.</li>
  </ol>
  
  <p>Creation and deletion reason can be null. </p>
  
  <p>Is it even possible? </p>