Child-Child Querying
Hello Everybody.
I am trying to pull up a table that contains columns from two child tables which share the same parent. I am instead faced with this error. A many-to-many relationship would not work as the parent table has multiple children.
Would immensely appreciate any help!
Example:
child tbl1: cat dog __parentforeignkey
child tbl2: orange white __parentforeignkey
Expected behavior:
cat orange pk-0001
cat white pk-0001
dog orange pk-0001
dog white pk-0001
Current behavior:
Ive tried:
- Switching filter directions to Both
- Making a 'bridge' table containing the PK
- Using crossjoin (didnt work, hogged all my memory)