SQL join Statement to query a Power BI Dataflow

Hello everyone! I am creating a dataflow (Gen 2) based on the existing PBI datasett in import mode. So I started with importing power query template to the dataflow. I have used following code to co...