Inner join in staging area

  • 8 February 2024
  • 1 reply

Userlevel 3
Badge +1

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?


Best answer by Christian Hauggaard 8 February 2024, 09:57

View original

1 reply

Userlevel 6
Badge +5

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).