Make-table query out of join query

[Victor70]

Hello,

Is it possible to create a make-table query out of a join query? If yes, how do I incorporate the INTO statement in my join query?
Whenever I change the type of the join query from SELECT to MAKE-TABLE, all my SQL statement gets deleted.

Thanks in advance.

 

[pr2-eugin]

Hmmm. I have not come across such things, infact i have used Make table query after joining two tables, and it works great.. post your query and we can see it.

 

[Victor70]

Here is the join query

select ID,EventID, Description, Expr2, Address, Date, Neighborhood 
from [VS - Progress Report (MTD) - A] 
union all
select  ID,EventID, Description, Expr2, Address, Date, Neighborhood  
from [VS - Progress Report (MTD) - B]

It sources the data from 2 subqueries (VS - ....). I guess the question is how to incorporate INTO statement into this.

Thanks a lot in advance.

 

[pr2-eugin]

Try this out, it should work..

SELECT * INTO makeTblName FROM(select ID,EventID, Description, Expr2, Address, Date, Neighborhood 
from [VS - Progress Report (MTD) - A] 
union all
select  ID,EventID, Description, Expr2, Address, Date, Neighborhood  
from [VS - Progress Report (MTD) - B])

 

[Victor70]

Wow.

I must admit that the syntax is not very much intuitive.

Thank you, pr2-eugin!