Guest jrudolph Posted November 16, 2005 Share Posted November 16, 2005 Hi all,I am trying to append data from one table into another table. A basic append query. Any ideas?Thanks, Link to comment Share on other sites More sharing options...
Jerome Posted November 16, 2005 Share Posted November 16, 2005 ... with access, sql server, mySQL ?Did you try manually? Link to comment Share on other sites More sharing options...
Kcarson Posted November 16, 2005 Share Posted November 16, 2005 I am assuming you mean you want to append the columns to the table rather than append the data from one column into another (i.e. concatenating the two). Assuming you do want to add the new columns to the table and all of the contents of those columns, see below.Well, if you are adding columns to the current table, then do that using the ALTER TABLE command.Then at that point there are two options.1. Create a view joining the two tables you are referencing. Example: CREATE VIEW test (column_names) AS SELECT * FROM table1 JOIN table2 WHERE table1.field1 = table2.field1 Then perform your update on the view.2. Try the query below: UPDATE table1 SET column_name FROM table1 JOIN table2 ON table1.field1 = table2.field1 You will have to play with these a bit, but they should at least get you started in the right direction. Link to comment Share on other sites More sharing options...
Vamsy Posted November 21, 2005 Share Posted November 21, 2005 Try this,select * into <New Table Name> from <Old Table Name> Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now