=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
Thanks for your help, but I just want
/* this condition */ lcreceive.due_date current_date
/* affect to */ SUM(lcreceive.amount_us)
/* and not */
SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS
open
Terence
--- Christensen, Dave [EMAIL PROTECTED]
ªº¶l¥ó¤º®e¡G SELECTlcopen.bank,