Association right access join does not show all records

1

After the association between the tables, the system shows only the records associated between the two tables: TBPaciente and TBMotivo .

SELECT TBPaciente.*, TBMotivo.* FROM TBMotivo RIGHT JOIN TBPaciente 
   ON TBMotivo.ID_MOTIVO = TBPaciente.ID_MOTIVO;
  

Ineedtoshowall6ThousandrecordsfromthePatientTypetable,what'swrong?

  

As you can see in the image above the system only shows 5 records which is the records that are associated, I need to show all 6,000 records.

    
asked by anonymous 11.02.2018 / 13:35

0 answers