title: Oracle query with multiple tables
body: <p>I am trying to display volunteer information with duty and what performance is allocated.
  I want to display this information. However, when I run the query, it did not gather the different date from same performance. And also availability_date is mixed up. Is it right query for it? I am not sure it is right query.
  Could you give me some feedback for me?
  Thanks.</p>
  
  <p><img src="https://i.stack.imgur.com/LOGc7.jpg" alt="enter image description here"></p>
  
  <p>Query is here.</p>
  
  <pre><code>SELECT Production.name, performance.performance_date, volunteer_duty.availability_date, customer.name "Customer volunteer", volunteer.volunteerid, membership.name "Member volunteer", membership.membershipid
  FROM Customer, Membership, Volunteer, volunteer_duty, duty, performance_duty, performance, production
  WHERE  
  Customer.customerId (+) = Membership.customerId AND
  Membership.membershipId = Volunteer.membershipId AND
  volunteer.volunteerid = volunteer_duty.volunteerid AND
  duty.dutyid = volunteer_duty.dutyid AND
  volunteer_duty.dutyId = performance_duty.dutyId AND
  volunteer_duty.volunteerId = performance_duty.volunteerId AND
  performance_duty.performanceId = performance.performanceId AND
  Performance.productionId = production.productionId
  </code></pre>
  
  <p>--Added image--
  Result:
  <img src="https://i.stack.imgur.com/8AHIe.jpg" alt="enter image description here"></p>