Hi Edward, thanks a lot for your hints. I will try it as soon as possible. Best regards, Glenn
"Becoming Digital" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > SQL isn't a spreadsheet program. It's a database programming language. As > such, it's not going to output tables in the manner you want. > > From what I see, it looks like you want to get individual results and a total > for each year. As best I can figure (without sub-selects), that will take two > queries, one to get the per-year info, another to get the total of that info. > > SELECT * FROM table WHERE year=YYYY; > SELECT sum(budget) FROM table; > > You then need some sort of scripting language to put this into the format you > desire. > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > ----- Original Message ----- > From: "Glenn" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, 12 June, 2003 06:25 > Subject: tables > > > 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] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
