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. )