MongoDb Atlas SQL Connector - Inner Join Tables

Hi Guys, we are working with the MongoDbConnector Atlas SQL in PowerBi, I’d like to know if it is possible to Inner Join Tables and also there is an extra challenge because the productid column needs to be extracted for one od the tables. I have a script like this .:

SUBSTRING(Cast(_id as string), 0, 24) AS _id,
SUBSTRING(Cast(productId as string), 0, 24) AS productId,
table1 Inner join ‘table2’ on ‘table1’.productId (For this table, needs to extract :SUBSTRING(Cast(productId as string), 0, 24)) =table2.productId