Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news-out.visi.com!petbe.visi.com!feed2.news.rcn.net!feed1.news.rcn.net!rcn!not-for-mail From: "Jake" Newsgroups: comp.databases.oracle.server Subject: How would I write this sql Date: Fri, 6 Jun 2003 21:38:40 -0500 Lines: 21 Message-ID: X-Trace: UmFuZG9tSVZhb/SOfFKebsT7HchFa8NzFavxqEv9gVK3ydcqbsljbctv2f+IKgKr X-Complaints-To: abuse@rcn.com NNTP-Posting-Date: 7 Jun 2003 02:38:53 GMT X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Priority: 3 X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MSMail-Priority: Normal Xref: core-easynews comp.databases.oracle.server:188950 X-Received-Date: Fri, 06 Jun 2003 19:38:17 MST (news.easynews.com) 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