title: SQL ORACLE Joining two queries together as one?
body: <p>thanks in advance for your help.</p>
  
  <p>I have a set of tables like this<a href="https://i.stack.imgur.com/KX18A.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KX18A.png" alt="the results from DESC queries"></a>. </p>
  
  <p>Also, here is a semi-accurate ERD to see what's going on.  <a href="https://i.stack.imgur.com/jBuoC.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jBuoC.jpg" alt="ERD"></a></p>
  
  <p>I need to list all donations made by individual Alumni, and businesses. I need the first/last name and IDs present. </p>
  
  <p>The following code returns all I need about the Alumni donors:</p>
  
  <pre><code>SELECT DonationID, Donation.AlumniID, BusinessID_FK, DONATIONDATE, Value, Alumnus.FirstName, Alumnus.LastName
  FROM DONATION 
  JOIN Alumnus 
     on Donation.AlumniID=Alumnus.alumniid;
  </code></pre>
  
  <p>And the following code returns all I need about the Business donors:</p>
  
  <pre><code>SELECT * FROM DONATION
  JOIN BusinessSponser 
     on Donation.businessid_fk=businesssponser.businessid;
  </code></pre>
  
  <p>Furthermore, the following query returns all the IDs, however no First/Last names:</p>
  
  <pre><code>SELECT * FROM DONATION
  LEFT JOIN BusinessSponser 
        on Donation.businessid_fk=businesssponser.businessid;
  </code></pre>
  
  <p>So my question is, how can I merge these queries together as one? My intention is to create a view that would display the final result.</p>
  
  <p>Thanks in advance for your help.</p>