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

[Neil Marshman]

Tracey

Try a GROUP BY m.ref

Cheers,

Neil

"Tracey Maule" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 14/03/2003 12:17 Please respond to delphi

To:        Multiple recipients of list delphi <[EMAIL PROTECTED]>         cc:                 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

---

Note:

This e-mail message has been scanned for Viruses and Content by both MailMarshal and Norton's Antivirus.

Attention:
The information contained in this message and or attachments is intended only for theperson or entity to which

it is addressed and may contain confidential and/or privileged material.  Any review, retransmission,

dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities

other than the intended recipient is prohibited.  If you received this in error, please contact the sender and
delete the material from any systen and destroy and copies.

Please note that the views and opinions expressed in this message may be those of the individual and not

necessarily those of Foodstuffs (South Island) Ltd

Thank You.

---