python - Combining two SQL Server log tables into a third activity log table

Question

State_Log_Table

EmployeeID	Time	Status
001	time1	2
001	time2	1
002	time3	2

question from:https://stackoverflow.com/questions/65875794/combining-two-sql-server-log-tables-into-a-third-activity-log-table

Answer 1

                     ```INSERT INTO 
                             Event_Log_Table (EMPLOYEEID,TIMESTAMP, ASSETID, STATUS)
                             SELECT
                             State_Log_Table.EMPLOYEEID, State_Log_Table.TIMESTAMP,Item_Log_Table.AssetID, State_Log_Table.STATUS
                             FROM
                             State_Log_Table
                             FULL OUTER JOIN Item_Log_Table
                             ON 
                             State_Log_Table.TIMESTAMP = Item_Log_Table.TIMESTAMP;
                            ```