* Dan Wilson <phpPgAdmin@acucore.com> [010225 22:47] wrote:
> I have the following query running on two different servers. It works on
> 7.0.3 and gives the following error on 7.1beta4.
>
> ERROR: Attribute 'last_name' not found
>
> Your SQL statement:
> SELECT first_name, last_name, middle_name, u.uid, end_year
> FROM user_info u, auth a
> WHERE u.uid = pri_key AND a.auth_table = 'user_info' AND live = 't'
> AND site_id IN ('214') AND u.end_year > date_part('year', date 'today') - 2
> UNION
> SELECT first_name, last_name, middle_name, u.uid, end_year
> FROM user_info u, current c
> WHERE u.uid = c.uid
> ORDER BY UPPER(last_name)
>
> I'm figuring it is in the ORDER BY, but I'm not sure. Can anyone help me
> out?
(just a guess) try adding the table name, like: 'u.last_name'.
--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]