This is my first post to the list. I could do with some pointers please. 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. I suspect it may use a temp table? I've no experience of that either. 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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php