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=lcreceive.id GROUP BY lcopen.bank;
_________________________________________________________ Lonely Christmas(陳奕迅),風箏與風(Twins),無間道(電影)... 至In手機鈴聲 陪你過冬天 http://ringtone.yahoo.com.hk --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php