How to make a pass-thru query a make table query

[jeep2001]

I have the following pass-thru query. I need to change it to create a table. What would the syntax be? Thanks


SELECT NACS.NAADRFTB.ACCOUNT_NO, NACS.NAADRFTB.UNF_LINE1_TXT, NACS.NAADRFTB.UNF_LINE2_TXT, FROM NACS.NAADRFTB;

 

[jeep2001]

I forgot to mention the native database is DB2

 

[lespaul]

I'm not sure a DB2 can do a make table like Access does. You may want to post in Forum178 (IBMB2). you may have to create the table and then insert the data.



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[dhookom]

jeep2001,
Where are you attempting to "make" the table. If you want to make it in Access, use the p-t query as the source of your make table query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]