Show blank records in Query


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?