Join and Filter

Been trying to do a Join and Filter Goal. To create a report containing PtId, Status,Email,Gender,Dx and First table I am able to pull all information but the Diagnosis

The Second table only contains Dx,

Each script I have will individually but I cannot seem to join.

SELECT pstatus, Sex,EmailAddress,First, Last,PId FROM dbo,PatientProfile AS t1 WHERE (pstatus=‘A’ and Sex=‘F’ and EmailAddress Like ‘%@%’) JOIN FHIR_Condition AS t2 ON t1.PId = t2 PID WHERE t2.ICD10CODE = ‘R39.81’