This is deceptively simple, and I very much appreciate your suggestion - but it doesn't work. Your suggestion still returns records that I should not see. Once again, there is a one to many relationship between an order_id in the order_id in the transaction response table. Please see my original email.
Thank you Paul sql query -----Original Message----- From: Brian Moon [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 25, 2002 12:11 AM To: Paul Maine; MySQL MySQL Subject: Re: SQL JOIN Challenge - Help Please If I read right, this is a pretty basic join so I am assuming that you have never done a join in your life. select distinct order.order_id from order inner join transaction_log on order.order_id=transaction_log.order_id and transaction_log.event_log_id <> 3 Brian. ----- Original Message ----- From: "Paul Maine" <[EMAIL PROTECTED]> To: "MySQL MySQL" <[EMAIL PROTECTED]> Sent: Saturday, August 24, 2002 7:31 PM Subject: SQL JOIN Challenge - Help Please | I have an order table and a transaction log table. The order table has an | order_id and a number of other columns that are not germain to my question. | The transaction log has an order_ID and an event_log_id column. The order id | from the order table will have a one to many relationship to the order_id | data in the transaction log table. The event_log_id is an integer that | assumes a value of 1 if the credit card is authorized, a value of 2 if the | credit card is denied or some other type of error, and a value of 3 if the | credit card is delay captured. | | I need to create a query that would return all of the order.order_ids that | are authorized but have not been delayed captured. How can I accomplish this | task? | | Thank You | Paul | sql query | | | --------------------------------------------------------------------- | 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 --------------------------------------------------------------------- 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