result_df = kunnr_azure_try.alias("kct").join(VW_T_AdjDefaultPrice.alias("t5"), (kunnr_azure_try.WAERS==VW_T_AdjDefaultPrice.TURR) & (kunnr_azure_try.ZW00_KONWA==VW_T_AdjDefaultPrice.FURR) , "inner").join(tcurr, tcurr.FCURR==kunnrmatnr_cond_azure_try.WAERS,"inner").where(tcurr.TYPE_RATE=="original").where(kunnrmatnr_cond_azure_try.marked==1).select("ZW00_kbetr","ZW00_basevalue",(tcurr.UKURS.alias("TUCURS")),"ZWF1_kbetr","ZWF1_value","ZW00_KPEIN")
result_df.display()
did a work around it worked for me...