I am trying to merge twelve tables in sql with the same column names but different data type in some columns but I’ve been unable to

Viewed 7
Select 
      divvy_trips_202004.ride_id,
    divvy_trips_202004.rideable_type,
    divvy_trips_202004.started_at,
    divvy_trips_202004.ended_at,
    divvy_trips_202004.start_station_name,
    divvy_trips_202004.start_station_id,
    divvy_trips_202004.end_station_name,
    divvy_trips_202004.end_station_id,
    divvy_trips_202004.start_lat,
    divvy_trips_202004.start_lng,
    divvy_trips_202004.end_lat,
    divvy_trips_202004.end_lng,
    divvy_trips_202004.member_casual
    FROM
    divvy_trips_202004
    FULL OUTER JOIN
    divvy_trips_202005 ON
    divvy_trips_202005.ride_id = divvy_trips_202004.ride_id
    FULL OUTER JOIN
    divvy_trips_202006 ON
    divvy_trips_202006.ride_id = divvy_trips_202005.ride_id
    FULL OUTER JOIN
    divvy_trips_202007 ON
    divvy_trips_202007.ride_id = divvy_trips_202006.ride_id
    FULL OUTER JOIN
    divvy_trips_202008 ON
    divvy_trips_202008.ride_id = divvy_trips_202007.ride_id
    FULL OUTER JOIN
    divvy_trips_202009 ON
    divvy_trips_202009.ride_id = divvy_trips_202008.ride_id
    FULL OUTER JOIN
    divvy_trips_202010 ON
    divvy_trips_202010.ride_id = divvy_trips_202009.ride_id
    FULL OUTER JOIN
    divvy_trips_202011 ON
    divvy_trips_202011.ride_id = divvy_trips_202010
    FULL OUTER JOIN
    divvy_trips_202012 ON
    divvy_trips_202012.ride_id = divvy_trips_202011
    FULL OUTER JOIN
    divvy_trips_202101 ON
    divvy_trips_202101.ride_id = divvy_trips_202012.ride_id
    FULL OUTER JOIN
    divvy_trips_202102 ON
    divvy_trips_202102.ride_id = divvy_trips_202101.ride_id
    FULL OUTER JOIN
    divvy_trips_202103 ON
    divvy_trips_202103.ride_id = divvy_trips_202102.ride_id
0 Answers
Related