#902 ✓resolved
yannick

Self Relational Many to Many Association not working

Reported by yannick | June 13th, 2009 @ 05:11 PM | in 0.10.2

http://gist.github.com/129451

on mysql it nearly works, it just fails to use aliases

SELECT users.id, users.login
FROM users 
INNER JOIN friendships ON friendships.user_id = users.id 
INNER JOIN users ON users.id = friendships.friend_id 
WHERE friendships.user_id = 1

Comments and changes to this ticket

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

Referenced by

Pages