search

HMIS / LSASampleCode

Longitudinal System Analysis (LSA) Sample Code and Documentation
22 stars 11 forks source link

Incorrect join #690

Closed eanders closed 3 years ago

eanders commented 3 years ago

Hi Molly, I think this should be hhid.EnrollmentID = nbn.EnrollmentID (or HouseholdID = HouseholdID). https://github.com/HMIS/LSASampleCode/blob/ee9a05715afde520bba7096f9caffc51489b4ae8/03_02%20to%2003_06%20HMIS%20Households%20and%20Enrollments.sql#L233

We're hitting issues with NbN clients. (This is the result of finally getting to digging into the source of: https://github.com/HMIS/LSASampleCode/issues/686)

MollyMcEvilley commented 3 years ago

Join should be on HouseholdID... commit forthcoming.