Sorry. I guess I should be more clear. Here's the SQL statement I'm using right now. INSERT INTO Table2 SELECT * From Table1
The problem with this is that in future versions of the software, we might want to add fields to Table1 but we still want people using the old version of the software...
I do not want the extra fields. Another note: The fields in t2 could differ for each query.
Is it possible to do a UNION ALL if the number of fields in the two tables are different?
Hi,
I have two tables, t1 and t2. I want to insert all the records from t1 into t2 but the tables have differing fields. t1 has all the fields that t2 has but it could possibly have extra fields too. Is there a SQL statement to do this? Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.