Re: mySQL query syntax error

I found the problem. The first subquery needed "AS" aliases. I am learning more of what mySQL is capable of and appreciate the help. Ron -----Original Message----- From: TG <tg-php@gryffyndevelopment.com> To: ron.piggott@actsministries.org Subject: Re: [PHP-DB] mySQL query syntax error Date: Sat, 14 Nov 2009 07:17:53 -0500 Only half awake and don't really see the problem with customers.email since you alias the two selects and union as 'customers'. But since you don't have any other tables in your primary select, you can drop the customers part and just say "ORDER BY email ASC". ----- Original Message ----- From: Ron Piggott <ron.piggott@actsministries.org> To: PHP DB <php-db@lists.php.net> Date: Sat, 14 Nov 2009 03:23:47 -0500 Subject: [PHP-DB] mySQL query syntax error > > I am getting the following error message: > > #1054 - Unknown column 'customers.email' in 'order clause' > > from the query below --- I don't understand why. Would someone help me > please? Ron > > > SELECT 'first_name', 'last_name', 'email' > FROM ( > > ( > > SELECT firstname , lastname , > buyer_email > FROM paypal_payment_info > WHERE datecreation = '$two_weeks_ago' > GROUP BY buyer_email > ) > UNION ALL ( > > SELECT > mail_order_address.first_name , > mail_order_address.last_name , > mail_order_address.email > FROM mail_order_address > INNER JOIN mail_order_payment ON > mail_order_address.reference = > > mail_order_payment.mail_order_address_reference > > WHERE > mail_order_payment.payment_received > = '$two_weeks_ago' > GROUP BY > mail_order_address.email > ) > ) AS customers > ORDER BY customers.email ASC > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >