如何根据2列比较PySpark中的2个数据帧？

from pyspark.sql import SparkSession
from pyspark.sql.functions import col

spark = SparkSession.builder.getOrCreate()

# 创建第一个数据帧
df1 = spark.createDataFrame([(1, "A"), (2, "B"), (3, "C")], ["id", "value1"])

# 创建第二个数据帧
df2 = spark.createDataFrame([(1, "X"), (2, "Y"), (4, "Z")], ["id", "value2"])

# 根据id列进行内连接
result = df1.join(df2, df1.id == df2.id, "inner")

# 根据value1列和value2列进行内连接
result = df1.join(df2, (df1.value1 == df2.value2), "inner")