SQL - add column from table to table : I got 2 tables:

first with 'CustomerID' and 'CustomerName' columns

second with 'CustomerName' and 'Product' columns

I want to add the 'CustomerID' column to the second table so it fit to corect customer (which can appear more than one time on this table)

tnx!

