one table is input into another
I have a routine that produces table1 records. These are records I want to status.
Table 2 is the status for the records. What I want to do is take the records that are
in Table 1 and add them to Table 2. The ids, serial are the keys. What is in table 1 isn't
in table 2. so I want to add the id, serial from table 1 to table 2 and hard code the status field and key_ed columns.
Table 1 id, serial
Table 2 id, serial, status, key_ed
I've been trying things like