Posted by Andy Kent on 11/22/05 14:51

What's the syntax for combining INTO and UNION clauses?

What I want to do is:

SELECT blah
INTO newtable
FROM oldtable1
WHERE <conditions>
UNION
SELECT blah
INTO newtable
FROM oldtable2
WHERE <conditions>

DTS doesn't seem to like my syntax. Where should the INTO(s) really go?

Thanks

Andy

• Next in forum: Re: Combining INTO with UNION
• Prev in forum: How to move two separate databases into one?
• Thread view: Combining INTO with UNION

[Reply to this message]