topic Re: inner join between cluster tables in Application Development and Automation Discussions

inner join between cluster tables

Former Member — Thu, 06 Sep 2007 07:19:56 GMT

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 — Thu, 06 Sep 2007 07:26:42 GMT

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 — Thu, 06 Sep 2007 07:40:53 GMT

Hi ,

In This case Used Select for all entries .

Regards,

Nihar Swain .

Former Member — Thu, 06 Sep 2007 07:42:52 GMT

Hi,

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

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

Reward if useful,

Thanks,

Gaurav Mittal