How do I correct this SQL code: I want to add one conditon to item "receive" lcopen : id, bank, unit_price_us, order_cbm lcreceive: id, amount_us, due_date
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; Terence Ng _________________________________________________________ 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