Hi there, i new here and i would like to seek for advise or help regarding this matter. I have trouble in joining 2 table.
the error is "type mismatch in expression"
the query is
Select R.*, P.HphoneNum, P.HeirHpNum from PendingReport R, PatientTable P Where P.PatientID = R.PatientID

but when i try the query without the "Where P.PatientID = R.PatientID" parameter, there were no error but the data keep repeating as the exist in both table.

Can anyone kindly advise or help me with this

Select R.*, P.HphoneNum, P.HeirHpNum from PendingReport R INNER JOIN PatientTable P ON P.PatientID = R.PatientID