Folks,
Newbie... So far, I've been building a database with
MySQL and I'm finding it seems to have a few
limitations. (I should say it's probably my lack of
knowledge rather than a failing of MySQl).
I'm now looking at switching to Postgresql simply
because it seems more feature-rich, specifically in
the problem I'm faced with.
I'm building a pupil assessment record. I have these
two tables:
table `pupil`
pupil_id name
1 jeff
2 fred
3 rita
table `reading_level`
record_id pupil_id week level
1 1 1 6.1
2 2 1 4.3
3 1 2 6.2
4 2 2 4.4
I'd really need to present this data thus:
name week1 week2 week3
jeff 6.1 6.2
fred 4.3 4.4
I believe it will involve a cross tab query, but I'm
completely lost. The real glory seems to be in writing
a query that will 'automatically' add new weeks as new
columns as more data is added to table
`reading_level`. In other words, the query doesn't
need rewriting after adding records for week 3, 4 etc.
Some query cleverness gets the weeks for itself.
Thanks for any help.
--
Matt Johnson
__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
