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?
Solved
Inner join in staging area
+4Best answer by Christian Hauggaard
Hi
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).
+5Hi
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
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
