Hi, some help needed.

I got a music-track and participants. For each music-track a participant can
take different roles, like artist or composer. So I got a table activity having
a music_track_id, a participant_id and a role_id.

Now I want music_track to have a relation mapping to give me all his artists,
i.e. all participants for this music-track with the role "artist".

How do I do that?

Added difficulty, how do I do that without prior knowledge about the kind of
desired role?

Thanks,
Florian





-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to