the query works, but i need to get the total number of songs on that CD, as well as the sum of the lengths of the songs on the CD... is that possible in 1 query?
On 8/2/06, Tanner Postert <[EMAIL PROTECTED]> wrote:
just to clarify to Brent, the songs lists the original artist and album. the CD table is for the information for a NEW mix CD. that CD contains the tracks listed in the tracks table, which point back to the individual songs. the reason the tracks are not listed in the songs table, is because they can be part of multiple CDs. one person could put that same song on tons of different mix CDs as wells as other users using it too, anyways, thanks for the help, i'll let you know how your suggestions faired. On 8/2/06, John Meyer <[EMAIL PROTECTED]> wrote: > > I've dealt with this in terms of Books and Titles. Those two are > separate: > one title can have many book editions published in it. Also, you can > have a > book with multiple titles (anthology, for instance). > I suppose it is possible for album not to be the same as cd title, > particularly if you have old vinyl albums around that you want to sell. > > -----Original Message----- > From: Brent Baisley [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 02, 2006 2:13 PM > To: Tanner Postert; mysql@lists.mysql.com > Subject: Re: Is this query possible? > > I'm not sure why you split out track, track is really kind of an > attribute > of a song. Especially since you have artist and album with the song. > Wouldn't album be the same as cd title? I'm not quite getting the logic > of > your schema. > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >
