Help on Unknown field error

2006-01-31 Thread pedro mpa
> -Mensagem original- > De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > "pedro mpa" <[EMAIL PROTECTED]> wrote on 01/31/2006 12:49:48 AM: > > > Greetings. > > > > I need help on the following query. > > I get an error like "Unknown/Invalid column total_price [...]" when I > try > > fil

Re: Help on Unknown field error

2006-01-31 Thread SGreen
"pedro mpa" <[EMAIL PROTECTED]> wrote on 01/31/2006 12:49:48 AM: > Greetings. > > I need help on the following query. > I get an error like "Unknown/Invalid column total_price [...]" when I try > filter by total_price. > How can I do this correctly? > > SELECT receipts.*, >(SELECT SUM(rece

Re: Help on Unknown field error

2006-01-30 Thread Michael Stassen
pedro mpa wrote: Greetings. I need help on the following query. I get an error like "Unknown/Invalid column total_price [...]" when I try filter by total_price. How can I do this correctly? SELECT receipts.*, (SELECT SUM(receipt_itens.price) FROM receipt_itens WHERE receipt_itens.id_

Help on Unknown field error

2006-01-30 Thread pedro mpa
Greetings. I need help on the following query. I get an error like "Unknown/Invalid column total_price [...]" when I try filter by total_price. How can I do this correctly? SELECT receipts.*, (SELECT SUM(receipt_itens.price) FROM receipt_itens WHERE receipt_itens.id_receipt=recei