Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Syntax Question

 4 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
DavidBrianCampbell
Basic Member
Posts: 13
Basic Member
9/24/2007 3:07 PM
    I have a query below that is erroring that the "FROM" is not in the correct place... any clues?.... Thanks!


    SELECT
    EMPLOYEE.EMPLOYEE,
    EMPLOYEE.FICA_NBR,
    EMPLOYEE.LAST_NAME,
    EMPLOYEE.ADDR1,
    EMPLOYEE.CITY,
    EMPLOYEE.ADDR2,
    EMPLOYEE.DEPARTMENT,
    EMPLOYEE.TERM_DATE,
    substr(DEPARTMENT,4,2),
    EMPLOYEE.ZIP,
    trim(employee.city) || ', ' || trim(employee.state) || ' ' ||
    trim(employee.zip) as city_st_zip,
    EMPLOYEE.STATE,
    EMPLOYEE.PROCESS_LEVEL,
    EMPLOYEE.FIRST_NAME,
    trim(last_name) || ', ' || trim(first_name) || ' ' ||
    case when trim(middle_init) is null then trim(middle_init)
    else trim(middle_init) || '.' end
    ONETIMED.EMPLOYEE
    FROM EMPLOYEE EMPLOYEE INNER JOIN ONETIMED ONETIMED ON
    EMPLOYEE.EMPLOYEE = ONETIMED.EMPLOYEE
    Will
    Veteran Member
    Posts: 39
    Veteran Member
    9/24/2007 3:13 PM
      Brian,

      You miss comas (,) after the 'end' and after 'ONETIMED.EMPLOYEE'.

      /Guillaume
      Will
      Veteran Member
      Posts: 39
      Veteran Member
      9/24/2007 3:16 PM
        EDIT: that's the forum not dispalying indentation, my bad.

        Also, think about identing your code for the lisibility:
        DavidBrianCampbell
        Basic Member
        Posts: 13
        Basic Member
        9/24/2007 3:21 PM
          I put in the below but
          but got a ORA-00936 'missing operator error:

          SELECT
          EMPLOYEE.EMPLOYEE,
          EMPLOYEE.FICA_NBR,
          EMPLOYEE.LAST_NAME,
          EMPLOYEE.ADDR1,
          EMPLOYEE.CITY,
          EMPLOYEE.ADDR2,
          EMPLOYEE.DEPARTMENT,
          EMPLOYEE.TERM_DATE,
          substr(DEPARTMENT,4,2),
          EMPLOYEE.ZIP,
          trim(employee.city) || ', ' || trim(employee.state) || ' ' || trim(employee.zip) as city_st_zip,
          EMPLOYEE.STATE,
          EMPLOYEE.PROCESS_LEVEL,
          EMPLOYEE.FIRST_NAME,
          trim(last_name) || ', ' || trim(first_name) || ' ' ||
          case when trim(middle_init) is null
          then trim(middle_init)
          else trim(middle_init) || '.' end,
          ONETIMED.EMPLOYEE,
          FROM EMPLOYEE EMPLOYEE INNER
          JOIN ONETIMED ONETIMED ON EMPLOYEE.EMPLOYEE = ONETIMED.EMPLOYEE
          Chris Martin
          Veteran Member
          Posts: 277
          Veteran Member
          9/24/2007 3:48 PM
            You were only missing the comma after "end". Remove the comma you just added after "ONETIMED.EMPLOYEE".