Insert table from table with different structure

Databases
1

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.

Thanks.

2 
INSERT INTO target
SELECT
    client
  , 0
FROM source
3

Very elegant guido2004. Thank-you.

I played with your code and found that it worked for a single additional text input:


INSERT INTO target
SELECT
    client
  , 'here'
FROM source

but not for TWO additional text inputs:


INSERT INTO target
SELECT
    client
  , 'here'
  , 'here2'
FROM source

What’s the notation for inserting selected data from a column in a source table into a target and filling the remaining two columns with token data?

4

But it does (assuming the table has three columns).
What error do you get?

5

Sorry for the false alarm. It must’ve been a obstacle illusion.

Working fine now.

Thank-you so much once again.