Re: SQL 101

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" <robert.m.manning@xxxxxxxxx>
>To: "Tyrone Baseck" <tyrone_bak@xxxxxxxxxxx>
>CC: squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
>Subject: Re: [Squirrel-sql-users] SQL 101
>Date: Sat, 17 Mar 2007 09:50:17 -0400
>
>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

_________________________________________________________________
Exercise your brain! Try Flexicon. 
http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglinemarch07


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