Re: SQL 101

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/


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV