Re: Question - Query

); INSERT INTO lcreceive VALUES (24,21.6442,'TPE158944-(06)',24674.39,'2002-11-11'); INSERT INTO lcreceive VALUES (25,19.1210,'740027353',21033.10,'2002-11-06'); INSERT INTO lcreceive VALUES (25,19.9400,'740027451',21934.00,'2002-11-14'); INSERT I

Re: Question - Query

First of all, thanks for your help. I have discovered that the result from: SELECT bank, SUM(unit_price_us * order_cbm) FROM lcopen GROUP BY bank; is different to the query you provided (row OPEN). How can I solve it? Terence Ng --- [EMAIL PROTECTED] wrote: > Hello Terence, > >

Re: Question -Subselect

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 corre

Question - subselect

pen SELECT lcopen.bank, SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open, # SUM(lcreceive.amount_us) where lcreceive.due_date < current_date, # # the above statement is not correct # FROM lcopen, lcreceive AND lcopen.id=lcreceive.id GROUP BY lcopen.bank; Tere

Question -Subselect

pen SELECT lcopen.bank, SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open, # SUM(lcreceive.amount_us) where lcreceive.due_date < current_date, # # the above statement is not correct # FROM lcopen, lcreceive AND lcopen.id=lcreceive.id GROUP BY lcopen.bank; Tere

Question - Query

pen SELECT lcopen.bank, SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open, # SUM(lcreceive.amount_us) where lcreceive.due_date < current_date, # # the above statement is not correct # FROM lcopen, lcreceive AND lcopen.id=lcreceive.id GROUP BY lcopen.bank; Tere

RE: Question - SELECT

rent_date >AND lcopen.id=lcreceive.id GROUP BY lcopen.bank; > > > Like this? > -----Original Message- > From: Terence Ng [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 03, 2003 7:09 PM > To: mysql > Subject: RE: Question - SELECT > > > Tha

Question - SELECT

the above statement is not correct # FROM lcopen, lcreceive AND lcopen.id=lcreceive.id GROUP BY lcopen.bank; #this condition :lcreceive.due_date < current_date #only affect to : SUM(lcreceive.amount_us) #and not : #SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open Tere

RE: Question - SELECT

d=lcreceive.id GROUP BY lcopen.bank; > > > I think this will work better. > > Dave > -Original Message- > From: Terence Ng [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 03, 2003 9:52 AM > To: mysql > Subject: Question - SELECT > > > How do I

Question - SELECT

_us) where lcreceive.due_date < current_date AS receive, # # the above statement is not correct for the # additional condition # FROM lcopen, lcreceive AND lcopen.id=lcreceive.id GROUP BY lcopen.bank; Terence Ng _ Lonely Christmas(³¯«³¨³)¡A­·ºå»P

Question - SELECT

e.due_date < current_date AS receive, # # the above statement is not correct for the # additional condition # FROM lcopen, lcreceive AND lcopen.id=lcreceive.id GROUP BY lcopen.bank; Terence Ng _ Lonely Christmas(³¯«³¨³)¡A­·ºå»P­·(Twins)¡AµL¶¡¹D(¹q

Question - SELECT

_us) where lcreceive.due_date < current_date AS receive, # # the above statement is not correct for the # additional condition # FROM lcopen, lcreceive AND lcopen.id=lcreceive.id GROUP BY lcopen.bank; Terence Ng _ Lonely Christmas(³¯«³¨³)¡A­·ºå»P

Question - SELECT

How do I correct this SQL code: SELECT lcopen.bank, SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open, # SUM(lcreceive.amount_us) where lcreceive.due_date < current_date AS receive, # # the above statement is not correct for the # additional condition # FROM lcopen, lcreceive AND lcopen.id

How to print the results to the printer in Windows2000 environment

Hi! How can I print the results to the printer in Windows2000 environment? Is there any MySQL command for this purpose? How about the MySQL Control Center? I have tried to search for an answer, but mostly for the unix system. Is there any simple solution since I am not a programmer? Terence

load data local infile

Hi, I have just upgraded to 3.23.54 How to input bulk data into table? I have tried: LOAD DATA LOCAL INFILE "lcopen1.txt" INTO TABLE lcopen; but it shows: ERROR 1148: The used command is not allowed with this MySQL version How come? What method can I use to input bulk data?

load data local infile

Hi, I have just upgraded to 3.23.54 How to input bulk data into table? I have tried: LOAD DATA LOCAL INFILE "lcopen1.txt" INTO TABLE lcopen; but it shows: ERROR 1148: The used command is not allowed with this MySQL version What did I miss? What method can I use to input bulk data?