Dear all,

trivial question. i have two tables that i would like to merge based on two columns. Basically i would like to translate to R what here i write in bash.

1st table (file a)

a   Solyc11g071810
a   Solyc11g071811
a   Solyc11g071812
a   Solyc11g071813
a   Solyc11g071814

2nd table (file b)

a   Solyc11g071810  low
a   Solyc11g071811  high
a   Solyc11g071812  medium
a   Solyc11g071813  very low
a   Solyc11g071814  medium
a   Solyc11g071819  very low
b   Solyc11g071813  high

Expected result (file c):

a   Solyc11g071810  low
a   Solyc11g071811  high
a   Solyc11g071812  medium
a   Solyc11g071813  very low
a   Solyc11g071814  medium

bash code:

cat a  | grep -w -F -f - b > c

thanks in advance for any help