Re: SQL pros I could use your help...

Not sure that I quite understand what you are after - do you want to insert new rows into table A based on the content of table B? Would this do the trick?

INSERT INTO tableA(description)
  SELECT UNIQUE description FROM tableB;   

scott_leadham_at_yahoo.com wrote:

>I have two tables that have 5 columns in each. Two of the columns in both
>tables should be identical, but they are not.
>
>In table A I have 176 rows for a column (description) when I should have 575
>like in Table B (description column).
>How can I populate table A's (description) column with data from table B's
>decription column so that it matches another column (type, which is in both
>tables) so they are in sync?
>
Received on Thu Apr 30 1998 - 04:22:26 CDT