Re: Why can't I still not use an ALIAS in the SELECT portion of an SQL statement?

2007-10-23 Thread mysql
[EMAIL PROTECTED] wrote: Daevid Vincent wrote: Nope. I've only ever use mySQL. I only ever care to use mySQL. mySQL puts in plenty of other features that no other RDBMS has or uses, and other RDBMS have features that mySQL has, so what's the problem. Unless I was porting to/from another RDBMS?

Re: Why can't I still not use an ALIAS in the SELECT portion of an SQL statement?

2007-10-23 Thread mysql
Daevid Vincent wrote: Nope. I've only ever use mySQL. I only ever care to use mySQL. mySQL puts in plenty of other features that no other RDBMS has or uses, and other RDBMS have features that mySQL has, so what's the problem. Unless I was porting to/from another RDBMS? This strikes me as a *ter

RE: Why can't I still not use an ALIAS in the SELECT portion of an SQL statement?

2007-10-23 Thread Daevid Vincent
- > From: Peter Brawley [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 23, 2007 5:39 PM > To: Daevid Vincent > Cc: mysql@lists.mysql.com > Subject: Re: Why can't I still not use an ALIAS in the SELECT > portion of an SQL statement? > > >When will I be able to do so

Re: Why can't I still not use an ALIAS in the SELECT portion of an SQL statement?

2007-10-23 Thread Peter Brawley
When will I be able to do something seemingly so basic as this re-use of an alias? Do you know an implementation of SQL which allows this? PB Daevid Vincent wrote: When will I be able to do something seemingly so basic as this re-use of an alias? SELECT DATE_ADD('2007-10-23', INTERVAL user_a

Why can't I still not use an ALIAS in the SELECT portion of an SQL statement?

2007-10-23 Thread Daevid Vincent
When will I be able to do something seemingly so basic as this re-use of an alias? SELECT DATE_ADD('2007-10-23', INTERVAL user_access_hours HOUR) AS group_duration_date, UNIX_TIMESTAMP(group_duration_date) AS group_duration_date_timestamp FROM end_user