Displaying 1 result from an estimated 1 matches for "members_versions".
2005 Sep 16
0
Max value for table having 2 joins
...releases
versions/version
has_and_belongs_to_many :members
belongs_to :songs
members/member
has_and_belongs_to_many :versions
songs
=====
Song1
Song2
Song3
members
=======
John
Paul
George
Ringo
The versions table lists all versions for all sings and is joined to members
via join table "members_versions".
I want a table which shows the latest versions members have for each song
John Paul George Ringo
Song1 1 2 1
Song2 3 3 1
Song3 1 1 2 2
This table then shows that eg: Song1 version 2 has only been sent to Paul,
that the latest version John and Ringo have is release 1 and that George
(p...