I have 2 tables,T1 and T2. There are 4 columns of T1 and 2 columns of T2
T2

1. 990334.  G000021
2. 844047.  G000025
3. 281739.  G000037
4  280903.  G002615
5  418546.  G004657

The data in T1
  V1            V2        V3      V4
1   T00015          AFP1 human G004657
2   T00035    AP-2alphaA human G002615
3   T00036          AP-4 human G003918
4   T00040            AR human G004953
5   T00045      COUP-TF2 human G004656


I want to construct T3 that has all the columns of T1 and T2 with the common
GOO$$$$  (common elements of column 4 of T1 and column 2 of T2.). I used
"match" but it did not work.

T3 should look like where  G002615 and G004657 are common.

T00015   AFP1        human G004657 418546.
T00035   AP-2alphaA  human G002615 280903.

any help would be appreciated.

	[[alternative HTML version deleted]]

