# Comparing data from same table but different user

**URL:** <https://community.glideapps.com/t/comparing-data-from-same-table-but-different-user/82700>\
**Category:** Ask for Help\
**Created:** [June 24, 2025, 8:51am UTC](https://community.glideapps.com/t/comparing-data-from-same-table-but-different-user/82700 "2025-06-24T08:51:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jikasef](https://avatars.discourse-cdn.com/v4/letter/j/d78d45/32.png) [@jikasef](https://community.glideapps.com/u/jikasef)\
**Post date:** [June 24, 2025, 8:51am UTC](https://community.glideapps.com/t/comparing-data-from-same-table-but-different-user/82700/1 "2025-06-24T08:51:38Z")

</div>

I have a golf score recoding app that records scores per hole by individual players (HoleScores table).  
I want to be able to pull scores per hole from the opponent and compare to determine the winner of the whole.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 24, 2025, 9:04am UTC](https://community.glideapps.com/t/comparing-data-from-same-table-but-different-user/82700/2 "2025-06-24T09:04:25Z")

</div>

Assuming that you have:

- A table that contains a list of Users (Players)
- and a reference to each player in your scores table

then you should be able to:

- create a query/relation from your Players table to your Scores table
- and then do a rollup through that query/relation
- and then present your players list on a collection, and sort by the rollup column