如何将pyspark dataframe列中的值与pyspark中的另一个dataframe进行比较

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', 'value'])
df2 = spark.createDataFrame([(1, 'X'), (2, 'Y'), (4, 'Z')], ['id', 'value'])

result = df1.join(df2, on='id', how='inner')

result.select(col('df1.value').alias('df1_value'), col('df2.value').alias('df2_value')).show()