Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: oratune@msn.com (David Fitzjarrell)
Newsgroups: comp.databases.oracle.server
Subject: Re: How would I write this sql
Date: 6 Jun 2003 21:45:05 -0700
Organization: http://groups.google.com/
Lines: 29
Message-ID: <32d39fb1.0306062045.37415c46@posting.google.com>
References: <bbrj7t$599$1@bob.news.rcn.net>
NNTP-Posting-Host: 66.148.209.194
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1054961106 27927 127.0.0.1 (7 Jun 2003 04:45:06 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 7 Jun 2003 04:45:06 GMT
Xref: core-easynews comp.databases.oracle.server:188957
X-Received-Date: Fri, 06 Jun 2003 21:44:22 MST (news.easynews.com)

"Jake" <oracle-news@heyjay.com> wrote in message news:<bbrj7t$599$1@bob.news.rcn.net>...
> How can I write this sql?
> 
> SQL> SELECT user.id
>   2  FROM   organization user
>   3  WHERE  userid = 'myname'
>   4  /
> SELECT user.id
>            *
> ERROR at line 1:
> ORA-00923: FROM keyword not found where expected
> 
> I'm not able to change the table alias.  And I know the error is from "user"
> being a pseudo column.
> 
> but is there some sort of quoting, or something I could do, and leave the
> table alias?
> 
> Thanks
> Jay


SELECT "user".id
FROM   organization "user"
WHERE  userid = 'myname';

should work.

David Fitzjarrell