SQL to empty businesses table and add desired information from all the businesses table together. More columns could be added if desired. Please keep same column name for the application to work properly.

UnifybusinessesTables.sql

-- NOTE: If you happen to delete the "businesses" table, Use: "CREATE TABLE businesses AS" instead of "INSERT INTO" and remember to attach the audit trigger.

-- Turn off temporarily the triggers.
SET session_replication_role = replica;

-- Empty businesses table.
TRUNCATE businesses;

INSERT INTO businesses(id, "INFOUSA_ID", geom, "PRIMARY_ADDRESS", "PRIMARY_CITY", "PRIMARY_STATE", "PRIMARY_ZIP_CODE","PRIMARY_ZIP4","PRIMARY_ZIP10","PRIMARY_CARRIER_ROUTE_CODE","PRIMARY_STATE_CODE","COUNTY_CODE","COUNTY_NAME","PROVINCE_CODE","PROVINCE_DESC",
					  "DISTRICT_CODE","DISTRICT_DESCRIPTION","POSTAL_CODE",alias,"COMPANY_NAME","NAICS_CODE","NAICS_DESC",
"LOCATION_EMPLOYMENT_SIZE_CODE","LOCATION_EMPLOYMENT_SIZE_DESC","ACTUAL_LOCATION_EMPLOYMENT_SIZE","ACTUAL_CORPORATE_EMPLOYMENT_SIZE","SQUARE_FOOTAGE_CODE","SQUARE_FOOTAGE_DESC",
"PRIMARY_SIC_CODE","PRIMARY_SIC_DESC","LOCATION_SALES_VOLUME_CODE","LOCATION_SALES_VOLUME_DESC","ACTUAL_LOCATION_SALES_VOLUME","CORPORATE_SALES_VOLUME_CODE",
  "CORPORATE_SALES_VOLUME_DESC","ACTUAL_CORPORATE_SALES_VOLUME","MATCH_LEVEL_CODE","INDIVIDUAL_FIRM_CODE","INDIVIDUAL_FIRM_DESC","YEAR_SIC_ADDED","BIG_BUSINESS","HIGHTECHBUSINESS","LATITUDE_1","LONGITUDE_1")
SELECT row_number() OVER () as id, *
FROM (
	  SELECT 
	"INFOUSA_ID" as "INFOUSA_ID",
	geom,
  "PRIMARY_ADDRESS" as "PRIMARY_ADDRESS",
  "PRIMARY_CITY" as "PRIMARY_CITY",
  "PRIMARY_STATE" as "PRIMARY_STATE",
  "PRIMARY_ZIP_CODE" as "PRIMARY_ZIP_CODE",
"PRIMARY_ZIP4","PRIMARY_ZIP10","PRIMARY_CARRIER_ROUTE_CODE","PRIMARY_STATE_CODE","COUNTY_CODE","COUNTY_NAME",
		Null as "PROVINCE_CODE",
	Null as "PROVINCE_DESC",
	Null as "DISTRICT_CODE",
	Null as "DISTRICT_DESCRIPTION",
  Null as "POSTAL_CODE",
  "COMPANY_NAME" as alias,
  "COMPANY_NAME" as "COMPANY_NAME",
  "NAICS_CODE" as "NAICS_CODE",
  "NAICS_DESC" as "NAICS_DESC",
  "LOCATION_EMPLOYMENT_SIZE_CODE" as "LOCATION_EMPLOYMENT_SIZE_CODE",
  "LOCATION_EMPLOYMENT_SIZE_DESC" as "LOCATION_EMPLOYMENT_SIZE_DESC",
  "ACTUAL_LOCATION_EMPLOYMENT_SIZE" as "ACTUAL_LOCATION_EMPLOYMENT_SIZE",
  "ACTUAL_CORPORATE_EMPLOYMENT_SIZE" as "ACTUAL_CORPORATE_EMPLOYMENT_SIZE",
  "SQUARE_FOOTAGE_CODE" as "SQUARE_FOOTAGE_CODE",
  "SQUARE_FOOTAGE_DESC" as "SQUARE_FOOTAGE_DESC",
  "PRIMARY_SIC_CODE" as "PRIMARY_SIC_CODE",
  "PRIMARY_SIC_DESC" as "PRIMARY_SIC_DESC",
  "LOCATION_SALES_VOLUME_CODE" as "LOCATION_SALES_VOLUME_CODE",
  "LOCATION_SALES_VOLUME_DESC" as "LOCATION_SALES_VOLUME_DESC",
  "ACTUAL_LOCATION_SALES_VOLUME" as "ACTUAL_LOCATION_SALES_VOLUME",
  "CORPORATE_SALES_VOLUME_CODE" as "CORPORATE_SALES_VOLUME_CODE",
  "CORPORATE_SALES_VOLUME_DESC",
  "ACTUAL_CORPORATE_SALES_VOLUME" as "ACTUAL_CORPORATE_SALES_VOLUME",
  "MATCH_LEVEL_CODE" as "MATCH_LEVEL_CODE",
  "INDIVIDUAL_FIRM_CODE" as "INDIVIDUAL_FIRM_CODE",
  "INDIVIDUAL_FIRM_DESC" as "INDIVIDUAL_FIRM_DESC",
  "YEAR_SIC_ADDED" as "YEAR_SIC_ADDED",
  "BIG_BUSINESS" as "BIG_BUSINESS",
  "HIGHTECHBUSINESS" as "HIGHTECHBUSINESS",
  "LATITUDE_1" as "LATITUDE_1",
  "LONGITUDE_1" as "LONGITUDE_1"
  from businesses_2019 as b
  union all
 SELECT
	"INFOUSA_ID" as "INFOUSA_ID",
  ST_TRANSFORM(geom,26918) as geom,
  "PRIMARY_ADDRESS" as "PRIMARY_ADDRESS",
  "PRIMARY_CITY" as "PRIMARY_CITY",
  "PRIMARY_STATE" as "PRIMARY_STATE",
  "PRIMARY_ZIP_CODE" as "PRIMARY_ZIP_CODE",
"PRIMARY_ZIP4","PRIMARY_ZIP10","PRIMARY_CARRIER_ROUTE_CODE","PRIMARY_STATE_CODE","COUNTY_CODE","COUNTY_NAME",
	Null as "PROVINCE_CODE",
	Null as "PROVINCE_DESC",
	CAST(Null as int) as "DISTRICT_CODE",
	Null as "DISTRICT_DESCRIPTION",
  Null as "POSTAL_CODE",
  "COMPANY_NAME" as alias,
  "COMPANY_NAME" as "COMPANY_NAME",
  "NAICS_CODE" as "NAICS_CODE",
  "NAICS_DESC" as "NAICS_DESC",
  "LOCATION_EMPLOYMENT_SIZE_CODE" as "LOCATION_EMPLOYMENT_SIZE_CODE",
  "LOCATION_EMPLOYMENT_SIZE_DESC" as "LOCATION_EMPLOYMENT_SIZE_DESC",
  "ACTUAL_LOCATION_EMPLOYMENT_SIZE" as "ACTUAL_LOCATION_EMPLOYMENT_SIZE",
  "ACTUAL_CORPORATE_EMPLOYMENT_SIZE" as "ACTUAL_CORPORATE_EMPLOYMENT_SIZE",
  "SQUARE_FOOTAGE_CODE" as "SQUARE_FOOTAGE_CODE",
  "SQUARE_FOOTAGE_DESC" as "SQUARE_FOOTAGE_DESC",
  "PRIMARY_SIC_CODE" as "PRIMARY_SIC_CODE",
  "PRIMARY_SIC_DESC" as "PRIMARY_SIC_DESC",
  "LOCATION_SALES_VOLUME_CODE" as "LOCATION_SALES_VOLUME_CODE",
  "LOCATION_SALES_VOLUME_DESC" as "LOCATION_SALES_VOLUME_DESC",
  "ACTUAL_LOCATION_SALES_VOLUME" as "ACTUAL_LOCATION_SALES_VOLUME",
  "CORPORATE_SALES_VOLUME_CODE" as "CORPORATE_SALES_VOLUME_CODE",
  "CORPORATE_SALES_VOLUME_DESC",
  "ACTUAL_CORPORATE_SALES_VOLUME" as "ACTUAL_CORPORATE_SALES_VOLUME",
  "MATCH_LEVEL_CODE" as "MATCH_LEVEL_CODE",
  "INDIVIDUAL_FIRM_CODE" as "INDIVIDUAL_FIRM_CODE",
  "INDIVIDUAL_FIRM_DESC" as "INDIVIDUAL_FIRM_DESC",
  "YEAR_SIC_ADDED" as "YEAR_SIC_ADDED",
  "BIG_BUSINESS" as "BIG_BUSINESS",
  "HIGHTECHBUSINESS" as "HIGHTECHBUSINESS",
  "LATITUDE_1" as "LATITUDE_1",
  "LONGITUDE_1" as "LONGITUDE_1"
  from businesses_ct_ma_ny_pa_vt as b
  union all
  SELECT 
	"INFOUSA_ID" as "INFOUSA_ID",
	ST_TRANSFORM(geom,26918) as geom,
  "ADDRESS" as "PRIMARY_ADDRESS",
  "CITY" as "PRIMARY_CITY",
  Null as "PRIMARY_STATE",
  Null as "PRIMARY_ZIP_CODE", Null as "PRIMARY_ZIP4", Null as "PRIMARY_ZIP10", Null as "PRIMARY_CARRIER_ROUTE_CODE", Null as "PRIMARY_STATE_CODE", Null as "COUNTY_CODE", Null as "COUNTY_NAME",
	"PROVINCE_CODE",
	"PROVINCE_DESC",
	"DISTRICT_CODE",
	"DISTRICT_DESCRIPTION",
  "POSTAL_CODE" as "POSTAL_CODE",
  "COMPANY_NAME" as alias,
  "COMPANY_NAME" as "COMPANY_NAME",
  "NAICS_CODE" as "NAICS_CODE",
  "NAICS_DESC" as "NAICS_DESC",
  "LOCATION_EMPLOYMENT_SIZE_CODE" as "LOCATION_EMPLOYMENT_SIZE_CODE",
  "LOCATION_EMPLOYMENT_SIZE_DESC" as "LOCATION_EMPLOYMENT_SIZE_DESC",
  "ACTUAL_LOCATION_EMPLOYMENT_SIZE" as "ACTUAL_LOCATION_EMPLOYMENT_SIZE",
  "ACTUAL_CORPORATE_EMPLOYMENT_SIZE" as "ACTUAL_CORPORATE_EMPLOYMENT_SIZE",
  Null as "SQFOOTCD",
  Null as "SQFOOTDS",
  "PRIMARY_SIC_CODE" as "PRIMARY_SIC_CODE",
  "PRIMARY_SIC_DESC" as "PRIMARY_SIC_DESC",
  "LOCATION_SALES_VOLUME_CODE" as "LOCATION_SALES_VOLUME_CODE",
  "LOCATION_SALES_VOLUME_DESC" as "LOCATION_SALES_VOLUME_DESC",
  Null as "ALSLSVOL",
  "CORPORATE_SALES_VOLUME_CODE" as "CORPORATE_SALES_VOLUME_CODE",
  "CORPORATE_SALES_VOLUME_DESC",
  "ACTUAL_CORPORATE_SALES_VOLUME" as "ACTUAL_CORPORATE_SALES_VOLUME",
  Null as "MATCHCD",
  "INDIVIDUAL_FIRM_CODE" as "INDIVIDUAL_FIRM_CODE",
  "INDIVIDUAL_FIRM_DESC" as "INDIVIDUAL_FIRM_DESC",
  Null as "YEAR_SIC_ADDED",
  Null as "BIG_BUSINESS",
  Null as "HIGHTECHBUSINESS",
  "LATITUDE_1" as "LATITUDE_1",
  "LONGITUDE_1" as "LONGITUDE_1"
  from businesses_can as b
	) as businessesss
order by row_number() OVER ();

SET session_replication_role = DEFAULT;