Is it possible to write queries in Excel data model for tables ?

[szakharov7723]

I have several tables (different data) in my Excel data model and I want to JOIN them with a manual sql query. Is it possible ?
If it is, how to do it ?

 

[Joe4]

I think you need to provide more information.
Most importantly, is there any relationship between these tables?
Or do they have the same data structures?
If the answer to both of those questions is "No", then how exactly do you expect to JOIN them?

Also, where exactly are you going to be doing this?
In VBA? MySQL? PowerQuery?

 

[szakharov7723]

I want to FULL OUTER JOIN them on Date
They are of different data structures, but both have Date column of same type.
There are no active relationship there.
I wanted to do this in PowerPivot or currently trying to see if I can do something in PowerQuery.
All I really need is data from both of these sources to create history charts.

P.S Can you query in VBA o_0

 

[szakharov7723]

Actually I have completed my task in a bit other way (I used Power Query) , so I close the question.