How to join 3 queries in a single query code?

[cgkas]

Hi everyone,

I created 2 separated queries and use Table.Combine() to merge Table1 and Table2 in a 3rd query named Table3, like below.

Table1

let
Source = MySource1 
in
Source

Table2

let
Source = MySource2 
in
Source

Table3

let
Merge = Table.Combine({Table1, Table2})
in
Merge

I'd like to know, if is there a way to get obtain Table3 in a single query (M code)? Something like this?

let
Source1 = MySource1, 
Source2 = MySource2,
Merge = Table.Combine({Source1, Source2})
in
Source

Thanks in advance for any help.

[parry2k · Accepted solution]

@cgkas yes you are right on track, it will work.

let
Source1 = MySource1, 
Source2 = MySource2,
Merge = Table.Combine({Source1, Source2})
in
Merge