I am trying to update the column 'lt_dispatch_level' in my table "inland" with the values from another table "current_obs" that has a corresponding column 'lt_dispatch_level'. However when I run this SQL query:
INSERT INTO inland
SELECT lt_dispatch_level, timestamp
I get the values from current_obs added in as a second row, with null values being aded in the first row. I attached an image of what this looks like.
What do I need to change in my SQL query to get my values in the first row?