Re: [DUG]: whats wrong with this small query?

[Tracey Maule]

aha!  (im sure i tried that) perfect thnks!   ----- Original Message ----- From: Steve Aish To: Multiple recipients of list delphi Sent: Friday, March 14, 2003 1:22 PM Subject: RE: [DUG]: whats wrong with this small query? You need   Group By m.ref   under the WHERE line. -----Original Message----- From: Tracey Maule [mailto:[EMAIL PROTECTED] Sent: Friday, 14 March 2003 01:18 To: Multiple recipients of list delphi Subject: [DUG]: whats wrong with this small query? looking around on the net etc, this query should theoretically work ok   select m.ref,  sum(e.quantity) as the_total from entry e join machine m on m.machineid = e.machineid where m.companyid = 1   however, running it in ibadmin, i get an "invalid column reference" error.  Of course, it is P.O.E.T.S day,  and they are full of cbf's,  but surely my eyes cant be that bad   why does this not work? Im running Firebird 1.0     Tracey Software Developer / Web Master Logis [EMAIL PROTECTED] (025) 213-1065 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 25/02/2003