Skip to main content

I have two tables Groups and GroupMembers. I need to get in GroupMember ONLY the members of the groups in the Groups table (INNER JOIN).

The only way in TX without using views is:

 

But it's not really a mistake.

How can I do it?

Hi @rvgfox 

Please review the Error relation settings in the following guide:

The relation setting is called Error because the related row will be moved to the error table if it does not exist in the table, and therefore does not necessarily signify a “mistake”. The method you describe would be the native TX approach (i.e. not using views).


Reply