SELECT Patient.ClientID, Patient.ID, Patient.MRNum, Patient.Compined, PatientStatus.Status, PatientStatus.Date, PatientStatus.DischargedDate, Patient.PrimDiag, PatientInsurance.InsuranceNumber, contact0.CompanyName, PatientLocation.Location4, PatientLocation.NPI AS NPI1 
FROM (Patient Patient
	 INNER JOIN PatientStatus PatientStatus
		 ON  Patient.MRNum = PatientStatus.MRNum2  AND  Patient.ClientID = PatientStatus.Clientid2 
	 INNER JOIN (PatientInsurance PatientInsurance
		 INNER JOIN contact contact0
			 ON  PatientInsurance.InsuranceID = contact0.id )
		 ON  Patient.ID = PatientInsurance.PatientID 
	 INNER JOIN PatientLocation PatientLocation
		 ON  Patient.ID = PatientLocation.Patientid4 ) 
WHERE (PatientStatus.Status NOT IN ('Pending', 'Non-Admit') ) AND  Patient.Record_delete <> 1  AND  PatientInsurance.PrimaryOrSecondary = 'Primary'  
ORDER BY Patient.Compined

SELECT p.ClientID
       , p.ID
       , p.MRNum
       , p.Compined
       , ps.[Status]
       , ps.[Date]
       , ps.DischargedDate
       , p.PrimDiag
       , pIns.InsuranceNumber
       , c.CompanyName
       , pl.Location4
       , pl.NPI AS NPI1 
FROM   Patient p
INNER JOIN PatientStatus ps
       ON  ps.MRNum2 = p.MRNum
       AND  ps.Clientid2 = p.ClientID 
INNER JOIN PatientLocation pl
	ON  pl.Patientid4 = p.ID 

left outer join PatientInsurance pIns
       on pIns.PatientID = p.ID
       and pIns.PrimaryOrSecondary = 'Primary'  
left outer join contact c
       on c.id = pIns.InsuranceID
		 
WHERE  ps.Status NOT IN ('Pending', 'Non-Admit')
AND    p.Record_delete <> 1  
ORDER BY p.Compined