This happens when one record of table matches to multiple records of another table, and vice versa.

Try with relationship="many-to-many" in the join statement

merged_data <- inner_join(distinct(flights), distinct(tickets), by = c("ORIGIN", "DESTINATION"), relationship="many-to-many")