Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join on Pooled table

Go to solution
Former Member

‎04-10-2008 9:37 AM

0 Kudos

Hi,

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

Regards

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎04-10-2008 9:40 AM

0 Kudos

u cann't join pooled tables.

u can join only transparent tables.

2 REPLIES 2

Go to solution
Former Member

‎04-10-2008 9:40 AM

0 Kudos

u cann't join pooled tables.

u can join only transparent tables.

Go to solution
former_member609120
Contributor

‎04-10-2008 9:42 AM

0 Kudos

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.