• Search Forums
    Advanced Search Topics Posts
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
New Member
Posts: 0
New 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
New Member
Posts: 0
New 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".