How to select observations in df 1 based on df 2?

Hi @Tung,

sorry, from this point on I could only guess.

Could you make a reproducible example (reprex) to make things clearer?

(My guess would be that you have not given the correct column names to join on. )