insert table from table with different structure
My target table has two columns (client, temp).
My source table has many columns including client.
How do I INSERT the target table from the source table without dropping the temp column before the insert?
I thought something like this would work , but no go.
Obviously, I can drop the temp column in the target table, INSERT from the source, and add the temp column, but I'd like to avoid that.
INSERT INTO target (temp) VALUES (0) SELECT client FROM source