title: How to show multiple tables list in MySql
body: <p>How to show multiple table list in mysql
  I have a query that has two tables
  one for patients and the second one for patients who has tested for covid-19
  I want to show all the patients either they tested or not
  If tested then show the result with his/her name
  It only showing the patients who has tested for the covid not every one</p>
  <p>how to solve that please ?</p>
  <p>here's my Query</p>
  <pre><code>SELECT patient.*  
  ,covidtest.covidTestResult ,subareas.areaname 
  FROM 
  ( patient LEFT OUTER  JOIN subareas
     ON  patient.town_id = subareas.town_id ) LEFT OUTER join covidtest  ON 
  patient.Idnumber = covidtest.Idnumber where 
  patient.Idnumber=covidtest.Idnumber and 
  covidtest.CovidTestDate=(select max(covidtest.CovidTestDate)from 
  covidtest where patient.Idnumber=covidtest.Idnumber) group by covidtest.Idnumber
   UNION SELECT patient.*  ,covidtest.covidTestResult,subareas.areaname  FROM 
   ( patient LEFT OUTER   JOIN subareas   ON 
    patient.town_id = subareas.town_id ) LEFT OUTER join covidtest  ON 
    patient.Idnumber = covidtest.Idnumber  where patient.Idnumber=covidtest.Idnumber 
    and covidtest.CovidTestDate=(select max(covidtest.CovidTestDate) from covidtest where 
    patient.Idnumber=covidtest.Idnumber) group by covidtest.Idnumber;
  
  </code></pre>