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-...@gryffyndevelopment.com>
To: ron.pigg...@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.pigg...@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
> 
> 

Reply via email to