title: Oracle Unique Record Retrival
body: <p>Having below three tables as described:</p>
  
  <pre><code>SELECT * FROM Users;
  
  UserID    UserName
  1          Ramesh
  2          Suresh
  
  
  SELECT * FROM UserAddress;
  
  UserAddressID    UserID     Address   
  1                  1          South St
  2                  1          North St
  3                  2          New St
  
  SELECT * FROM UserDegree;
  
  UserDegreeID      UserID      Degree
  1                  1            BSC
  2                  2            B.Tech
  3                  2            M.Tech
  </code></pre>
  
  <p>I need output like given below,</p>
  
  <pre><code>UserID  UserName  UserAddressID   UserID   Address  UserDegreeID  UserID  Degree
  1        Ramesh     1               1     South St    1            1       BSC
  NULL      NULL      2               1     North St    NULL         NULL    NULL
  2        Suresh     3               2     New St      2            2      B.Tech
  NULL      NULL      NULL           NULL   NULL        3            2      M.Tech
  </code></pre>
  
  <p>Can anyone help me to get this output without using any looping?</p>