How would I write this sql

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 Received on Fri Jun 06 2003 - 21:38:40 CDT