Hi All,
I have a Tenant table and want the query to list all tenants in Age bracket between age 14 and 24. But since we have the mobile no of the main tenant we also want to show their record as well. In certain cases the main tenant can also be in the age group 14 -24 and should include these tenants as well.
Below is how the view should look like. I have uploaded sample data here: https://app.box.com/s/ky3ry6x5zk587j7nvuk76dg0ezmsv3kn
Tenant Code | Title | Full Name | Age | Member Type | Relationship to Head | Mobile |
42447 | Ms | Wendy | 50 | Main Tenant | NA | 123231 |
42447 | Miss | Jamie | 14 | Member | DAU | |
42447 | Miss | Kristen | 18 | Member | DAU |
Thanks
- Edited by jaggy99 59 minutes ago