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
---
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
