topic Re: Regarding Inner Join in Application Development and Automation Discussions

Regarding Inner Join

Former Member — Mon, 03 Sep 2007 08:36:08 GMT

Hi All,

Inner join is possible on pooled tables, cluster table. How???

If Yes, then plz tell me how..

if not, then wat can we do against pooled tables, cluster table, any other option for inner join.....

Regards,

Anil Kumar

Re: Regarding Inner Join

Former Member — Mon, 03 Sep 2007 08:41:33 GMT

Hi,

To my knowledge, Inner Join is not possible in the case of CLUSTER table.

Best way is to get records separately to two internal tables from other tables and CLUSTER tables, then join these two internal tables using for all entries. This will definitely work.

Try and reward if found useful.

Re: Regarding Inner Join

Former Member — Mon, 03 Sep 2007 08:42:09 GMT

Hi,

inner joins are possible in cluster and pooled tables

but if we use then the performance will be very poor..

for eg

take bseg is a cluster table

instead of going to bseg table

we have the related transparent tables like

vbsegk, " Document Segment for Vendor Document Parking

vbsegd, " Document Segment for Customer Document Parking

vbsegs, " Description Document Segment for Document Parking - G/L Account data base.

like these.. and so many

better to write select on these tables and loop the itab

for inner joins

SELECT a_{field1 a}field2 a~field3

b~field1

b_{field2 b}field3

from bseg as a inner join bkpf as b

on a_{field1 = b}field1

where conditions.

thanks & regards,

Venkatesh

Re: Regarding Inner Join

Former Member — Mon, 03 Sep 2007 08:43:14 GMT

hi anil,

go thro this link.

Regards...

Arun.

Re: Regarding Inner Join

Former Member — Mon, 03 Sep 2007 08:44:45 GMT

Hi Anil,

Inner join is not possible for cluster tables

so we can get the data from the table into internal tables and join that

internal tables using FOR ALL ENTRIES.

Regards,

Azhar

Re: Regarding Inner Join

Former Member — Mon, 03 Sep 2007 08:58:55 GMT

Hi Venkatesh,

If u use the coding like u mentioned in the reply, u will get the following error message,

For pooled tables, cluster tables and projection views, JOIN is not allowed.

So, u cannot use join in pooled and cluster tables.

Try to check it.