嗨，我有两张table。

create table analytics_cem_db.AA
(msisdn string,
first_latch int,
last_latch_cell int,
mo_ab_release int,
mo_nml_release int,
time_key int);

以及

create table analytics_cem_db.BB
(msisdn string,
first_latch int,
last_latch_cell int,
mt_ab_release int,
mt_nml_release int,
time_key int);

我需要把这些表连接起来，以得到下面的模式。aa和cc具有相似和不相似的msisdn值

create table analytics_cem_db.CC
(msisdn string,
first_latch int,
last_latch_cell int,
mo_ab_release int,
mo_nml_release int,
mt_ab_release int,
mt_nml_release int,
time_key int);