RE: book categories

2009-02-23 Thread Jerry Schwartz
-Original Message- From: PJ [mailto:af.gour...@videotron.ca] Sent: Sunday, February 22, 2009 2:39 PM To: MySql Subject: book categories Here's a tough one... In my library I have some 62 categories where a number of books can be in several categories. Now, to relate the categories

Re: book categories

2009-02-22 Thread Claudio Nanni
Hi Phil, relax you are on track! First a little theory. In this case you have the so called N-to-M relationship. While if you need to relate one book to one author(given only one author per book!) you have the so called 1-to-N relationship, in this case you have the N-to-M relationship. If you are

Re: book categories

2009-02-22 Thread PJ
Claudio Nanni wrote: Hi Phil, relax you are on track! First a little theory. In this case you have the so called N-to-M relationship. While if you need to relate one book to one author(given only one author per book!) you have the so called 1-to-N relationship, in this case you have the