Community
Application Development and Automation 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: 
Read only

Join on Pooled table

Go to solution
Former Member

‎2008 Apr 10 9:37 AM

0 Likes
635

Hi,

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

Regards

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2008 Apr 10 9:40 AM

0 Likes
502

u cann't join pooled tables.

u can join only transparent tables.

2 REPLIES 2
Read only

Go to solution
Former Member

‎2008 Apr 10 9:40 AM

0 Likes
503

u cann't join pooled tables.

u can join only transparent tables.

Read only

Go to solution
former_member609120
Contributor

‎2008 Apr 10 9:42 AM

0 Likes
502

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.