我有两个表，我想根据日期条件在R中连接它们，但它似乎不起作用

# 创建两个示例表
table1 <- data.frame(date = c("2022-01-01", "2022-01-02", "2022-01-03"),
                     value1 = c(1, 2, 3))
table2 <- data.frame(date = c("2022-01-01", "2022-01-03", "2022-01-04"),
                     value2 = c(4, 5, 6))

# 将两个表按照日期连接起来
merged_table <- merge(table1, table2, by = "date")

# 打印连接后的表
print(merged_table)

        date value1 value2
1 2022-01-01      1      4
2 2022-01-03      3      5

library(dplyr)

# 创建两个示例表
table1 <- data.frame(date = c("2022-01-01", "2022-01-02", "2022-01-03"),
                     value1 = c(1, 2, 3))
table2 <- data.frame(date = c("2022-01-01", "2022-01-03", "2022-01-04"),
                     value2 = c(4, 5, 6))

# 将两个表按照日期连接起来
joined_table <- inner_join(table1, table2, by = "date")

# 打印连接后的表
print(joined_table)

        date value1 value2
1 2022-01-01      1      4
2 2022-01-03      3      5