|
From: Tyrone B. <tyr...@ho...> - 2007-03-16 18:46:18
|
SELECT PERS_ROLE_HIST.ASGN_TS AS [Assignment Date], Trim(Pers.lst_nm)+" ,"+Trim(pers.fst_nm) AS Name, DIV.DIV_NM AS Division, PERS_ROLE_HIST.AUTH_REQ_ID AS [Order #], ROLE.ROLE_CD, PERS_ROLE_HIST.ASGN_TS, PERS_ROLE_HIST.UNASGN_TS, PERS.TERM_DT, PERS.PERS_ID FROM ROLE INNER JOIN ((PERS INNER JOIN DIV ON PERS.DIV_NBR = DIV.DIV_NBR) INNER JOIN PERS_ROLE_HIST ON PERS.PERS_ID = PERS_ROLE_HIST.PERS_ID) ON ROLE.ROLE_ID = PERS_ROLE_HIST.ROLE_ID WHERE (((PERS.PERS_ID)=3321)) ORDER BY PERS_ROLE_HIST.ASGN_TS, Trim(Pers.lst_nm)+" ,"+Trim(pers.fst_nm); I'm new. Why am I receiving the following error? Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0104N An unexpected token "[Assignment Date]" was found following "ROLE_HIST.ASGN_TS AS". Expected tokens may include: "<space>". SQLSTATE=42601 , SQL State: 42601, Error Code: -104 _________________________________________________________________ Get a FREE Web site, company branded e-mail and more from Microsoft Office Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/ |
