[DUG]: whats wrong with this small query?

[Tracey Maule]

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