1
After I made 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;
I need you to show all the 6 thousand records table Tbpaciente, what is wrong ?
As you can see in the image above the system shows only 5 records which is the records that are associated, I need you to show all 6,000 records.
You are using the query for registration?
– novic
Yeah, I’m using it for registration.
– hard123
Make a direct form and add the relationship later, so it works
– novic