combine_tables.sql

create table combined_accounts_contacts
as select A.*,
          B.company_id,
          B.first_name,
          B.last_name
    from defaultdb_public_accounts A
    full join defaultdb_public_contacts B
    on A.external_id = B.company_id;