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:
![](https://uploads-eu-west-1.insided.com/timextender-en/attachment/5338578f-f932-4250-9cc0-538c8f78b6e1.png)
But it's not really a mistake.
How can I do it?
Best answer by Christian Hauggaard
View original