How to join multiple datasets in the Advanced editor using M code

[Bhargav150]

I need to rewrite the below SQL code in M code, 

Select * from CTE1 A

Left join CTE2 B On A.JN  = B.LN or A.OLN = B.LN

[adudani · Accepted solution]

hi @Bhargav150 

in the power query editor:
1. how to merge queries with a left join : Power BI Tutorial: Merge Queries in Power Query (youtube.com)

2. To join on multiple columns, hold "CTRL" to select multiple column headers while merging.
Alternatively, you can create a key ( merging multiple columns if required) 
: https://www.youtube.com/watch?v=j-RBZQbWQOM&pp=ygUSam9pbnMgaW4gcG93ZXIgYnVp 

if this doesn't resolve the issue, kindly provide sample input and output data masking sensitive information