inner join between cluster tables

[Former Member]

HI experts

i have used inner join between cdpos and cdhdr tables.

it says that, not able to put inner join within cluster tables.

how can we process join with these two tables.

Thanks in advance.

Regards

Rajram

[Former Member]

hi

Cluster tables are generally contain large volume of data and it is mainly used for control data rather than application data.

You can not perform JOINs on Cluster tables.

secondary index is not created for thode tables,so v r not using select query also.

so no way to write inner join or for all.......

reward if helpful

vivekanand

[Former Member]

Hi ,

In This case Used Select for all entries .

Regards,

Nihar Swain .

[Former Member]

Hi,

U can't use join on cluster and pooled tables...

better u use for all entries......

Reward if useful,

Thanks,

Gaurav Mittal