Re: Question -Subselect

2003-01-11 Thread Terence Ng
Please help! I already know that my query is wrong. I have identified it. But what is the solution to my query? --- gerald_clark <[EMAIL PROTECTED]> wrote: > I answered this yesterday. > Your FROM must precede your WHERE. > > Terence Ng wrote: > > >How do I correct this SQL code: > > > >2 t

Re: Question -Subselect

2003-01-09 Thread gerald_clark
I answered this yesterday. Your FROM must precede your WHERE. Terence Ng wrote: How do I correct this SQL code: 2 tables there, lcopen: id, bank, unit_price_us, order_cbm lcreceive: id, amount_us, due_date #this condition :lcreceive.due_date < current_date #only affect to : SUM(lcreceive.amou