Sql query is returning same rows

Question

Hey Guys i want to thank you again for all the support you rendered it make my coding skill improve and i keep learning more and more.

 

I have a challenge i am trying to retrieve patient record when the patient enrollement ID is found from a View called "HIVENCOUNTER" let me show it with Table

 

tbl_HIVENCOUNTER

Ptn_pk	PatientID	Drug	Duration	Wieght	VisitID	VisitDate
00245	101001	ART	30	140	111	10/01/2001
00245	101001	ART	60	100	122	05/02/2001
00245	101001	ART	30	110	212	03/03/2001
00246	101002	ART	90	120	121	12/01/2001
00246	101002	ART	30	150	1414	06/02/2001
00246	101002	ART	120	60	1415	10/03/2001

 

 Based on the above table i want to retrieve record as follows :

 

select * from tbl_HIVENCOUNTER t

Inner Join mst_patient p on t.Ptn_pk = p.Ptn_pk and p.PatientID = '101001'

order by t.VisitDate Asc

 

it return just two record instead of three as following : 

 

Ptn_pk	PatientID	Drug	Duration	Wieght	VisitID	VisitDate
00245	101001	ART	30	140	111	10/01/2001
00245	101001	ART	60	100	122	05/02/2001

 

 i also modify the script like this

 

Select * from tbl_HIVECOUNTER t where t.Ptn_pk = (Select ptn_pk from mst_patient where PatientID = t.PatientID) order by t.VisitDate

 

this also is returning the same result, i am implementing this code with C# loop "While loop"

 

Note : mst_Patient is the master patient table that contain the demographic record of each Patient 

 

 

any suggestion will be appreciated. Thank you all