I have a custom query in the following format:
Table A (parent)
- Table B (child)
– Table C (child-child)
Table A and B as well as Table B and C are linked in an ExistJoin.
The issue is that when Table C contains a blank record, Table B records will not appear even though Table B records exist and relate to Table A. Unfortunately, I need this to work, any thoughts?