Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2012
    Posts
    2

    Unanswered: Problem Writing SQL Query - getting ORA-00923 message

    Good afternoon,

    I'm new to writing SQL Queries. I use Oracle SQL Developer.

    The current error I'm receiving with my query is: "ORA-00923: FROM keyword not found where expected."

    I'm not sure what I need to change in order to get this query to work correctly. I've attached the query for you to take a look at.

    Any help you can give will be greatly appreciated!
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You should go ask the person who originally wrote the SQL; since it obviously was not you.

    Realize that we don't have your tables & don't have your data.
    Therefore we can't run, test, or improve posted code.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2012
    Posts
    2
    Thanks - I appreciate your help.

  4. #4
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    Sorry! Parentheses looks good.

    There were at least one syntax doubts in the query.

    Code:
    ...
    A.sc_Location_Name AS Location,
    A.first_name /* no colon */
    A.last_name,
    ...
    Last edited by tonkuma; 07-04-12 at 12:44. Reason: Remove a mismatch of parentheses.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •