Using Sub Tables With Join

Wappler General How To
,
#1

Hi.
I have a MSSQL DB with three tables: A, B, C.
C has a sub-table relation with B.
A & B have foreign-key relation as well.

If I create a query with B as the first table, and select C as a column, it works well.
But, if I create a query with A as the first table, inner join it with table B, and then try to use C as a column, I am getting a Object reference not set to an instance of an object. error.

Is such configuration not supported with sub tables?

1 Like
#2
#3

Could you give some extra information, a stacktrace would be nice to have with the filename and linenumber where the error occurs. You should be able to use sub tables within joins.