Re: Simple thing that i should probably know ...

[Jim Faucette]

Ed Williams wrote:
> 
> I have two identical tables with one column
> all i want to do is merge them into one big table.
> and get rid of the duplicates at the same time...
> any ideas??
> oh yeah the column names are identical in both tables but this can be changed.
> 

CREATE table3 col_name same_def_as_others NOT NULL PRIMARY KEY;
INSERT INTO table3 SELECT DISTINCT col_name FROM table1;
INSERT INTO table3 SELECT DISTINCT col_name FROM table2;

   jim...