adworldmedia
asked on
SQL Server 2005: SELECT INTO new TABLE two SELECT statements UNION'ed?
I'm looking to import two select statements union'ed together that is using a distinct to get unique records:
select * into cpv2649 from
select distinct keyword from
(select keyword from bcastcpv
union
select keyword from lfmain1) as list
But it gives me an error. Any ideas on what I can do to acomplish this?
Thanks,
Joe
select * into cpv2649 from
select distinct keyword from
(select keyword from bcastcpv
union
select keyword from lfmain1) as list
But it gives me an error. Any ideas on what I can do to acomplish this?
Thanks,
Joe
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.