Include All Records In Join

[ScottECE]

I have joined 3 tables in a view and the default join type is "Include only matching records".  I would like to "Include all records", but this is grayed out and I am not allow to select it.  What could be preventing me from selecting it?

 

Thanks,

Scott

[Jan]

Hello Scott,

 

Welcome to Caspio forum!

 

As far as I know, when you select the type of join for the first relation between two tables, all other relations for these two tables will be added with this type.

If I understand correctly, you can delete relations and create new relations with another type of join.

 

I hope, it helps.