Skip to content

Instantly share code, notes, and snippets.

@montrealist
Last active December 30, 2020 19:58
Show Gist options
  • Save montrealist/3846146a3f10653dc87dc02183a79b63 to your computer and use it in GitHub Desktop.
Save montrealist/3846146a3f10653dc87dc02183a79b63 to your computer and use it in GitHub Desktop.
sql join on tinder like site
select evalutions.shownId
from evalutions
inner join evalutions as OtherEvaluations
on evalutions.uid = OtherEvaluations.shownId
and OtherEvaluations.res = yes
where evalutions.uid = 'K' and evalutions.res = yes
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment