How would I write a query like this using Exposed? ``` SELECT requested.GroupId, requested.Member, r...

# exposed

[jonathan]

How would I write a query like this using Exposed?

SELECT requested.GroupId, requested.Member, requested.isAdmin, requested.isOwner
  FROM GroupMembers requested, GroupMembers requestor
  WHERE requested.GroupId = 1 AND requested.Member = 1 AND requestor.GroupId = 1 AND requestor.Member = 2

[tapac]

Use aliases https://github.com/JetBrains/Exposed/wiki/DSL#alias

[jonathan]

Ah excellent thank you!