insert into second table, where a null rows exist
Hi all!
I got a Problem and dont know, how should I solve this case
so...
there are 2 tables PS_DOC and WD_KDOC_NEU.
Table WD_KDOC_NEU got 25056875 rows, but there are also 325209 NULL rows in column KD_LNR_DEST_PS_DOC.
I would like to insert all rows into WD_KDOC_NEU table from PS_DOC table, where the rows are null.
Basically, I have to add the following data and fill my WD_KDOC_NEU table.
Source | Destination |
PS_DOC.KD_LNR_DEST | WD_KDOC_NEU.KD_LNR_DEST_PS_DOC |
described tables:
desc WD_KDOC_NEU