Hi David, Sum() is an aggregate function that sums exactly one column.
Try using: ( sum(a)+sum(b)+sum(c) ) / sum(d) Best regards/Med venlig hilsen Lars V. Nielsen GisPro, Denmark http://www.gispro.dk/ ----- Original Message ----- From: "Dewen Hou" <[EMAIL PROTECTED]> To: "Mapinfo-L" <mapinfo-l@lists.directionsmag.com> Sent: Wednesday, August 17, 2005 9:38 PM Subject: MI-L SQL question Hi All, I couldn't do a SQL like "sum(a+b+c)/sum(d)" in Mapbasic. Any idea? Thanks a lot, David Hou --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17526
