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]
