Skip to Content
0
Former Member
Feb 16, 2009 at 08:21 PM

Can we apply join between two internal tables?

501 Views

Itab has fields A,B,C.

Data: begin of itab occurs 1,

A type I,

B type I,

C type I,

End of itab.

Jtab has fields A, I, J.

Data: begin of itab occurs 1,

A type I,

I type I,

J type I,

End of itab

The common field between itab and jtab is u201CAu201D.

Now I need to collect A,B,C,I, J in another internal table ktab.

How should I be doing this.

If I use a SELECT query with inner join between itab and jtab it says u201Citab is not a database tableu201D.

How should I get the result ktab with A B C I J fields?

Please help, nay help will be highly appreciated?