Re: SQL 101

On 3/16/07, Tyrone Baseck <tyrone_bak@xxxxxxxxxxx> wrote:
> 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

Try quoting column aliases with quotes ("") instead of brackets ([])

Rob

-------------------------------------------------------------------------
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