How to INSERT values into 1 column from another table
From: Unknown User <unknown_at_unknown.com>
Date: Tue, 12 Jun 2001 11:32:05 -0700
Message-ID: <elncito6d90u5kje48pvgc98fi8fr9b1c5_at_4ax.com>
Date: Tue, 12 Jun 2001 11:32:05 -0700
Message-ID: <elncito6d90u5kje48pvgc98fi8fr9b1c5_at_4ax.com>
I added a column called COMMENTS to a table called INVOICE.
I have another table called SHIPPING with a column called SHIP_METHOD
I want to copy from shipping.ship_method to invoice.comments.
How is it accomplished?
I tried copy and insert into and would appreciate the proper syntax.