Regarding Inner Join

[Former Member]

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,

<b>Anil Kumar</b>

[Former Member]

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.

[Former Member]

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

<b>for inner joins</b>

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

[Former Member]

Hi Venkatesh,

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

<b>For pooled tables, cluster tables and projection views, JOIN is not allowed. </b>

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

Try to check it.

[Former Member]

hi anil,

go thro this link.

Regards...

Arun.

[Former Member]

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.

<b>

Regards,

Azhar</b>