Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
MyTable:
LOAD Sales FROM table1;
INNER JOIN
LOAD Sales FROM table2;
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;
PFA....