New DB manager - can't make the join I want

@George I still think there’s something missing with the new db setup, please have a look.

I have a table schools with a cross ref table events which connects schools with events:

Here my table events:
image

I want to create the following query:


my issue: I want to do “school_events.id equal {{schoolid}}” (1) but I can’t do that because the that school_events.id is in a subquery now instead of a join.

So I should be able to fix this by: joining school_events on events (used to be possible).
But now when I try to make the join:
I can’t select the school_events table

only a schools table where I can see the `schools.events as an option to pick but this doesn’t make sense.

Then it creates a join on schools.events (which is NOT a column, but it’s a multi-ref subtable as you can see in the very first screenshot). image

How can I create this join?


I think this issue is the same as the unresolved part in this thread: New db manager subtables - can't create the join I want?

Community Page
Last updated: