,'COSU84413670',14724.72,'2003-03-05');
INSERT INTO lcreceive VALUES
(53,42.7090,'COSU84413690',29042.12,'2003-03-04');
INSERT INTO lcreceive VALUES
(54,22.0430,'COSU84413730',13887.09,'2003-03-05');
Best regards,
Terence Ng
--- [EMAIL PROTECTED] wrote: Hello,
Yes I think I see what you
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,
I posted
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 tables
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;
Terence Ng
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;
Terence Ng
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;
Terence Ng
=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
Thanks for your help, but I just want
/* this condition */ lcreceive.due_date
,
#
# 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
Terence Ng
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·(Twins)¡AµL¶¡¹D
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¼v)...
¦ÜIn¤â
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·(Twins)¡AµL¶¡¹D
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 correct this SQL code:
2 tables there, and I want to add one conditon to
item receive lcopen :
id, bank
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
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
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?
Terence Ng
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?
Terence Ng
16 matches
Mail list logo