Re: [Squirrel-sql-users] SQL 101
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Tyrone B. <tyr...@ho...> - 2007-03-20 15:28:23
|
I will get help from the DBA on that query listed earlier. The one listed below works. Now, what is it doing: select * from MGD_REQ_HOLDG m inner join AUTH_REQ_ITEM_HDR a on m.REQ_ITEM_HDR_ID = a.REQ_ITEM_HDR_ID where a.auth_req_id Do I need to change the MGD_REQ_HOLDG in the first line to look at another table? What is the lower case "m" and "a" for? Why do you need to add a "a" to a.REQ_ITEM_HDR_ID instead of doing it without the "a"? Sorry... This is SQL for dummies questions. >From: "Robert Manning" <rob...@gm...> >To: "Tyrone Baseck" <tyr...@ho...> >CC: squ...@li... >Subject: Re: [Squirrel-sql-users] SQL 101 >Date: Sat, 17 Mar 2007 09:50:17 -0400 > >On 3/16/07, Tyrone Baseck <tyr...@ho...> 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 _________________________________________________________________ Exercise your brain! Try Flexicon. http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglinemarch07 |