Combine data from two different sources in the same query?

[MR2001]

Is it possible to merge data from two different data sources within the same query, something like:

Source1 = Json.Document(Web.Contents("https://rsq-tm.com/cqweb/oslc/repo/MYschema/db/CCP/query/40853228?&rcm.contentType=application/json&...
 
Source2= Json.Document(Web.Contents("https://rsq-tm.com/cqweb/oslc/repo/MYschema/db/CCP/query/38703771?&rcm.contentType=application/json&...

#"Converted to Table" = Record.ToTable(??? - Source1 union Source2 - ???)
Value = #"Converted to Table"{2}[Value]
etc......
 
thank you

[Greg_Deckler · Accepted solution]

Sure, use a Merge or Append query, the M function is Table.Join.

[ImkeF]

Table.Join is equivalent to SQL-JOINS (with all options as well!).

What you need here is Table.Combine({Source1, Source2}) (or Append if you do it via the UI). This is the equivalent to the SQL-UNION.