Go to View tab, and click on Advanced Editor: You can apply any join type that you want simply by going to advanced editor, and changing the M script as below: You can change it to inner join with selecting “Only include matching rows”. You should follow the same path through Merge Queries, and then you will see joining options as below:Īs you see the default behavior is Left join.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |