Inner Join Statement (A table & a query)

[VAer]

I have two tables: Table_abc Table_xyz
XyzQuery is a query from Table_xyz
I would like to set up AbcQuery which needs inner join XyzQuery

How to correct my Inner Joint statement?

Thanks.

Since SQL statement is not allowed to be posted, so I add some space inbetween.

Please Login or Register  to view this content.

[kasan]

Why do you need Xyz Query?

Please Login or Register  to view this content.

[VAer]

Why do you need Xyz Query?

I need to copy XyzQuery to a separate excel spread sheet, and I also need to copy AbcQuery to a separate excel sheet.

[kasan]

Ok,
1) run your query XyzQuery and return result on one sheet

Please Login or Register  to view this content.

2) run query from post #2 and return result to another sheet

[VAer]

Ok,
1) run your query Xyz

yes, the issue is the code cannot understand AbcQuery

[kasan]

Did you test query from post #2?

Please Login or Register  to view this content.

[VAer]

Did you test query from post #2?

Okay, I will take out second part then test. Currently it cannot compile with part 2 code.

[kasan]

Show us whole code you try to make work.

[VAer]

Show us whole code you try to make work.

The code is able to copy XyzQuery into a speadsheet. I would prefer not to show the whole code, since it is not necessary, and more importantly, it is work-related(not personal stuff). If I show the whole code, I need to replace a lot of words. And the program get involved with other tasks, query is just part of code.