[SQL] Re: [PHP-DB] Problem regarding 'select...as...'

[Vince LaMonica]

On 2000-06-12, Bernie Huang stated:

} "select equip_attr[1], equip_attr[2]
} as year, make
} from vehicle_tb;"
} 
} which gives me the following error:
} 
} "ERROR:  Attribute 'make' not found"
} 
} Is there something wrong with my "as" usage?  Thanks

Try: 
        "select equip_attr[1] as year, equip_attr[2] as make"
instead.

HTH,

/vjl/