Hey there! I'm querying a database of users and a database of pages where each page is assigned to a user via a user id. I want to select users whose pages fit a particular conditional, so I'm using an inner join with the following standard condition:
user.id == page.user_id
However, the result of this join is that each user that matches the condition appears as a duplicate dozens of times. In SQL, I've encountered this before, and I would normally tinker with the ON condition or add a DISTINCT somewhere, but I'm not sure how to do any of those things in Xano. I can remove duplicates manually with an JS lambda but because the data is paginated, I can only remove the duplicates from the one page that's returned, resulting in only one or two results per page instead of 10 or so. What are some things I can do to fix this?