Hi, I have this: +----+-------+--------+ ¦ Jahr ¦ Name ¦ Budget ¦ +----+-------+--------+ 2003 Hans 2000 2003 Fritz 5000 2004 Hans 1500 2005 Pia 3500
How is it possible to make this in sql? +---------------------+ ¦ 2003 Hans 2000 ¦ ¦ 2003 Fritz 5000 ¦ +---------------------+ ¦ Total 7000 ¦ +---------------------+ +---------------------+ ¦ 2004 Hans 1500 ¦ +---------------------+ ¦ Total 1500 ¦ +---------------------+ +---------------------+ ¦ 2005 Pia 3500 ¦ +---------------------+ ¦ Total 3500 ¦ +---------------------+ Thanks a lot, Glenn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
