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.
INSERT INTO target (temp) VALUES (0) SELECT client FROM source
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.