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.