Hello, I have a small(hopefully) sql-query problem. I have 2 table like this:
Table member: Id number, Name varchar, Table member_points: Id number Member__id number (fk from member_table) Round number Points number Now one example: In table one is a member called stefan. In table member_points are 5 sets for member stefan with his points for every round. Now I need one select, to give me his Name and all his points in _one_ row like this: Name round 1 round 2 round 3 round 4 Stefan 10 15 8 12 Who can help me? Greetings and thanks, Stefan --------------------------------------------------------------------- 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