Re: [SQL] design of tables for sparse data

2007-11-13 Thread Erik Jones
On Nov 12, 2007, at 8:10 PM, Andreas wrote: Fernando Hevia schrieb: --- Andreas Wrote: --- ... MY QUESTIONS: Your questions have a strong "home-work" look. Yes but I didn't want to bother everyone with my project's details. It's more like a CRM. Up until now I just tried to manage someho

Re: [SQL] design of tables for sparse data

2007-11-12 Thread Andreas
Fernando Hevia schrieb: --- Andreas Wrote: --- ... MY QUESTIONS: Your questions have a strong "home-work" look. Yes but I didn't want to bother everyone with my project's details. It's more like a CRM. Up until now I just tried to manage somehow with the sql basics and now I like t

Re: [SQL] design of tables for sparse data

2007-11-12 Thread Fernando Hevia
> --- Andreas Wrote: --- > ... > > MY QUESTIONS: Your questions have a strong "home-work" look. > > 1) How would I SELECT a report that looks like the first version of > the pupil table out of the 3 table design? > There must be a nontrivial SELECT statement that combines all 3 tables. > E.g