SQL

Question

@ Brian My Model table column MOD_WAIT_CHG has same datatype numeric since I am dropping & sign.
My charter table has column CHAR_WAIT_CHG which is also numeric.
I have to copy the data from MOD_WAIT_CHG to CHAR_WAIT_CHG

I used the statement
INSERT INTO CHARTER(CHAR_WAIT_CHG) SELECT MODE_WAIT_CHG FROM MODEL
WHERE MOD_WAIT_CHG = 100
I m getting an error red line under CHAR_WAIT_CHG I have declared the column
Please help

Answer 1

Could you post the table scheme and insert statement as they appear on the database