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 .:

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

Thanks