Hi @Tung,
you could do this e.g. with an inner_join on all relevant columns.
library(tidyverse)
tbl1 <- tibble(FIRST = c("John", "Joe", "Mary"),
LAST = c("A", "B", "C"),
MORE = c(34,87,99))
tbl2 <- tibble(FIRST = c("Mary"),
LAST = c("C"),
EVEN_MORE = c(111))
# both
inner_join(tbl1, tbl2, by = c("FIRST", "LAST"))
#> # A tibble: 1 x 4
#> FIRST LAST MORE EVEN_MORE
#> <chr> <chr> <dbl> <dbl>
#> 1 Mary C 99 111
Created on 2020-10-23 by the reprex package (v0.3.0)