topic Re: Table Alias in Application Development and Automation Discussions

Table Alias

Former Member — Wed, 16 Dec 2009 11:02:23 GMT

Hello

I need to access twice the same table with the help of aliases.

I tried this

SELECT DISTINCT CHILD~NODENAME PARENT~NODENAME into table it_org_hierarki FROM /BI0/HORGUNIT AS CHILD
      JOIN /BI0/HORGUNIT AS PARENT ON PARENT~NODEID = CHILD~PARENTID.

But I get an run-time error DBIF_RSQL_INVALID_RSQL.

How can I get what I'm looking for ? Isn't it possible to use an alias to access the same table twice in a SELECT?

Re: Table Alias

Former Member — Wed, 16 Dec 2009 11:09:59 GMT

Ignore

Edited by: Nitwick on Dec 16, 2009 4:41 PM

Re: Table Alias

Former Member — Wed, 16 Dec 2009 11:16:36 GMT

Hi,

I think you are getting this error coz the internal table is over filled.


SELECT DISTINCT CHILD~NODENAME PARENT~NODENAME into table it_org_hierarki FROM /BI0/HORGUNIT AS CHILD
      JOIN /BI0/HORGUNIT AS PARENT ON PARENT~NODEID = CHILD~PARENTID.  "Use the WHERE clause and fetch only the records that you want

Re: Table Alias

Former Member — Wed, 16 Dec 2009 11:33:46 GMT

It's ok now.

I simply had a bad definition in my internal table. It didn't match with the 2 selected fields .

Sorry.

Re: Table Alias

Former Member — Tue, 02 Aug 2011 17:46:12 GMT

did you manage to solve this, I'm trying to read the orgunit hierarchy table to find all the child nodes under each parent orgunit, can some one guide me please?