Insert column from other table / merge tables
If date &amp; time are identical and work as a unique identifier in both tables:

SELECT 
    t1.date,
    t1.time,
    COALESCE(t1.windspeed,t2.windspeed) as windspeed,
    COALESCE(t1.winddir,t2.winddir) as winder
FROM t1 INNER JOIN t2 ON t1.date = t2.date AND t1.time = t2.time


This is a query for create table:

CREATE TABLE tblName AS

SELECT 
      t1.date,
      t1.time,
      COALESCE(t1.windspeed,t2.windspeed) as windspeed,
      COALESCE(t1.winddir,t2.winddir) as winder
FROM t1 INNER JOIN t2 ON t1.date = t2.date AND t1.time = t2.time


To work properly (fast), create combined indexes on both tables on (date, time).