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
Start Free Trial