根据依赖于数据帧某些字段值的参数化SQL查询，在Spark Dataframe中添加列

I have several Spark Dataframes(we can call them Table a, table b etc). I want to add a column just to table a, based on a result of a query to one of the other tables, but this table will change every time based on a value of one of the fields of table a. So this query should be parametric. Below I show an example to make the problem clear:I have several Spark Dataframes(we can call the