Difficulty combining Insert Into or Select Into with a Union, please help!

[anon3803]

I am having difficulty getting a query to work, there's probably something really simple I'm missing. . . I can get the Union function to work but I can't get it to create a table for me. The basic query looks like this:

INSERT INTO test
SELECT * FROM [Design] WHERE (Design.CID Not Like "*-*")
UNION
SELECT * FROM [Release] WHERE (Release.CID Not Like "*-*")

It works fine and shows me the table I want without the first line, but I would like it to input into a new or existing table. Any help would be greatly appreciated!

 

[Moniker]

Separate out the INSERT INTO part into its own query. Make the UNION SELECT its own query, and then make an INSERT INTO query based on that UNION QUERY.