title: SQL - Multiple select statements, one column, one query
body: <p>I have a table called person, which has a primary key called person_id. The person table contains information about patients and doctors (initals, last_name etc). I also have another table called appointment, which contains a doctor_id, patient_id and information about the appointment. The doctor_id and patient_id are linked to the person_id in the person table.</p>
  
  <p>I need to make a query that will return the name of the doctor (using concat with initials and last_name) and the name of the patient.</p>
  
  <p>I've tried using nested select statements but didn't get anywhere..</p>
  
  <p>Any information would be great!</p>
  
  <p>Dan</p>