Question: I want to accomplish something of the following:

```
Select DISTINCT(tableA.column) INTO tableB.column FROM tableA

```

The goal would be to select a distinct data set and then insert that data into a specific column of a new table.

Answer: 
Try the following...

```
INSERT INTO tableB (column)
Select DISTINCT(tableA.column)
FROM tableA

```
> The goal would be to select a distinct data set and then insert that data into a specific column of a new table.

I don't know what the schema of tableB is... if table B already exists and there is no unique constraint on the column you can do as any of the others suggest here....
`INSERT INTO tableB (column)Select DISTINCT(tableA.column)FROM tableA`
but if you have a unique constraint on table B and it already exists you'll have to exclude those values already in table B...
`INSERT INTO tableB (column)  

Select DISTINCT(tableA.column)  

FROM tableA   

WHERE tableA.column NOT IN (SELECT /* NOTE */ tableB.column FROM tableB)   

-- NOTE: Remember if there is a unique constraint you don't need the more  

-- costly form of a "SELECT DISTICT" in this subquery against tableB  

-- This could be done in a number of different ways - this is just   

-- one version. Best version will depend on size of data in each table,   

-- indexes available, etc. Always prototype different ways and measure perf.`