title: Sql Query Join in Oracle
body: <p>I have Parent table and multiple child tables with foreign key constraint. </p>
  
  <pre><code>School Table
  
  School ID EduDetails Genders Address_id  EDUTYPE
    1        2          M         3         FGN
  </code></pre>
  
  <p>And the child tables like</p>
  
  <pre><code> Education Details
   EDU ID    EducationType
    2        Online
  
   AKA Name
   School Id   AKA Name
       1       Test School
       1       School Test
  
   Gender Table
   Gender ID   Gender Desc
        M      Male  
  </code></pre>
  
  <p>I am using Left outer join for the parent and school table to fetch the results.</p>
  
  <p>But My issue is, If AKA table has 5 counts matching the school Id and Gender table has only 1 records for that school Id. </p>
  
  <p>So the results comes with 5 duplicate rows with school Information and also other child table information. </p>
  
  <p>Is there any workaround to fix this issue. I tried using subquery and row_number over by function. But it is not working for me. Can anybody help me to solve this issue.</p>
  
  <p>Thanks in advance for your time in looking this issue.</p>
  
  <p>My required output should be like this</p>
  
  <pre><code> School_id AKA Name     GenderDesc EductaionType
     1       Test School    Male       Online
     1       School Test          
  </code></pre>
  
  <p>So I need to have Null values for the not matching records.</p>