topic Re: Join on Pooled table in Application Development and Automation Discussions

Join on Pooled table

Former Member — Thu, 10 Apr 2008 08:37:08 GMT

Hi,

i wont to do Join on pooled table and i have error what is wrong?

Regards

Former Member — Thu, 10 Apr 2008 08:40:25 GMT

u cann't join pooled tables.

u can join only transparent tables.

former_member609120 — Thu, 10 Apr 2008 08:42:51 GMT

You cannot use a join on a pool or clustered table...

suppose you have table A and B..

Between A and B, join is not possible

So, select data from table A into itab_a

then select data from table B for all entries in itab_a where condn.