started on adding patients
problem with joins for select statements.
fixed problem with joins in select statements.
fixed my botched fix