MS QUERY SQL syntax

Hi Guys,

I am trying to create inner join between 2 tables within different workbooks like below:

MS QUery.png

I do not know what exactly syntax should look like, i was trying with :

Please Login or Register  to view this content.

How can i do it?

(it is MS Query, not a power query).
Best Wishes,
Jacek

Anyone?

Jacek

Hi Guys,

it is possible?

Jacek

Hi,

Generally, you are missing a join condition. In order to join two tables you have to specify how these two tables are joined:

1. Which type of join it is (inner, left, right, full...)
2. Which fields are used for joining (table1.ID vs table2.ID for example)..

This would mean that your come more or less looks ok, however, you are missing "ON" clause after INNER JOIN... This is explained in the article linked by Alan.

Hello! Same problem here, I'm kind of dummy though

Ussually I join tables in that scheme:


SELECT `Arkusz1$`.kol1, `Sheet1$`.kol2, `Sheet1$`.kol3
FROM `C:\Users\USER\FILE_ONE.xlsx`.`Sheet1$` `Sheet1$`

UNION ALL

SELECT `Arkusz1$`.kol1, `Sheet1$`.kol2, `Sheet1$`.kol3
FROM `C:\Users\USER\FILE_TWO.xlsx`.`Sheet1$` `Sheet1$`


(and so on depending on quantity of tables)



How to do it using join?
Could anyone give some example?

Hi Guys,

i tried solutions from your link above and i do not still why my syntax is incorrect.

Please share a sample.

I appreciate any help,
Best Wishes
Jacek

Hi Guys,

please help,

Jacek

Hi Guys,

still the problem with this.

I am thinking if it is possible at all.

I am trying to implement code:

Please Login or Register  to view this content.

but i have to do inner join in correct way:
Select * from Table1 inner join Table2 on Table1.Col1 = Table2.Col2

I has to give the name to a table in order to create inner join perhaps?

In attachment please see my sample files and queries.
Please Help,
Jacek Antek

You can do that with PowerQuery (add-in for Ex2010)

Yes,

but i am boss and i know what is an answer here ;-)

For all inner join for example in attachment:

Please Login or Register  to view this content.

Jacek