How to get a table showing only rows that exist in both tables?

[nenadvukovic]

Hi, if I have something like this:

Table1:

Fld, Pd, Val

A, 5-17, 1

B, 5-17, 1

C, 5-17, 2

D, 5-17, 3

Table 2:

Fld, Pd, Val

B, 5-18, 3

D, 5-18, 4

E, 5-18, 3

F, 5-18, 5

And I want to get only this in Table3:

B, 5-17, 1

B, 5-18, 3

D, 5-17, 3

D, 5-18, 4

Thanks

Message was edited by: Nenad Vuković to make it more realistic

[Chanty4u]

try this

Table1:

l

A

B

C

D

  inner join

Table2:

B

D

E

F

[Chanty4u]

check this liknk

Understanding Join, Keep and Concatenate

[arvind1494]

load * from Table1;

inner join

load * from Table2;

[nenadvukovic · Accepted solution]

Is there a smarter solution:

T1:

load * inline [

Fld, Pd, Val

A, 5-17, 1

B, 5-17, 1

C, 5-17, 2

D, 5-17, 3];

T2:

noconcatenate load * inline [

Fld, Fld1, Pd, Val

B, B, 5-18, 3

D, D, 5-18, 4

E, E, 5-18, 3

F, F, 5-18, 5]

where exists(Fld);

concatenate load * resident T1 where exists(Fld1, Fld);

drop table T1;

drop field Fld1;