This will help, it seems: http://www.mysql.com/articles/wizard/page3.html
Xi2 -----Original Message----- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 10:11 AM To: [EMAIL PROTECTED] Subject: mysql query I am trying to write a query that gets the name of every carrier who has done more than $600 in loads. Can anyone help? SELECT c.name FROM carrier c, loads l WHERE c.CID_NO = l.CID_NO AND SUM(l.amount > 600); This, unfortunately does not work. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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