Member Avatar for zulfahmi

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

  • 2 Contributors
  • 1 Reply
  • 87 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by Oxiegen
Member Avatar for Oxiegen

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.