search

nz-social-investment-agency / social_investment_analytical_layer

Standardised tables for doing cross agency work in the IDI - NOTE: Currently being updated due to IDI SAS Grid and Windows 10 migration
GNU General Public License v3.0
12 stars 5 forks source link

SIAL_HNZ_register_events doesn't show all applications #11

Closed vinaybenny closed 7 years ago

vinaybenny commented 7 years ago

This is because an inner join is applied between housing application tables and register exit. This fetches only those records that are either housed or exitted. The applications still on register does not appear. This needs to be changed to a left join.

vinaybenny commented 7 years ago

Issue closed with commit 9f0eb99