select data from two tables

[#1]

Hi experts,

I have two tables, T1 and T2 as below,

T1:

Sales
A
B
C
D

T2:

Sales
A
C
E

Then, I want to find out the same sales from T2 when sales name is same as T1. What about the scripts for this?

Display result in T2 :

Sales
A
C

Thanks

Jessica

[Gysbert_Wassenaar]

MyTable:

LOAD Sales FROM table1;

INNER JOIN

LOAD Sales FROM table2;

[avinashelite]

if you don't want the table to get merge use the INNER KEEP

MyTable:

LOAD Sales FROM table1;

INNER KEEP

LOAD Sales FROM table2;

[nagarjuna_kotha]

PFA....