Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!cyclone1.gnilink.net!spamkiller2.gnilink.net!nwrdny02.gnilink.net.POSTED!53ab2750!not-for-mail From: "Anurag Varma" Newsgroups: comp.databases.oracle.server References: Subject: Re: How would I write this sql Lines: 31 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: Date: Sat, 07 Jun 2003 03:03:21 GMT NNTP-Posting-Host: 151.198.156.130 X-Complaints-To: abuse@verizon.net X-Trace: nwrdny02.gnilink.net 1054955001 151.198.156.130 (Fri, 06 Jun 2003 23:03:21 EDT) NNTP-Posting-Date: Fri, 06 Jun 2003 23:03:21 EDT Xref: core-easynews comp.databases.oracle.server:188952 X-Received-Date: Fri, 06 Jun 2003 20:02:38 MST (news.easynews.com) user is a reserved word in oracle .. try some other alias. see v$reserved_words for the list of reserved words Anurag "Jake" 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 > >