两张表进行join怎样取出只有一个表中才有的数据

select count(1)

from

(

select t1.dt dt,t1.uid uid,t1.search_arr_city dep_city,t1.search_dep_city arr_city,date_add(t1.datee,3) as dep_date

from

(

select a.uid uid,dt,a.qtraceid qtraceid,search_dep_city,search_arr_city,a.dep_city dep_city,a.arr_city arr_city,datee from

(select dep_date,arr_city,dt,qtraceid,dep_city,uid from f_analysis.new_big_traffic_server_log where dt='20200614' and jump_back_uniquekey

is not null)a

inner join

(select dep_date,arr_city,to_date(dep_date) datee, dep_city,uid from f_wide.wide_order where dt='20200614')b

on a.arr_city=b.arr_city and a.dep_city=b.dep_city and a.uid=b.uid

left join

(select qtraceid,dep_city search_dep_city,arr_city search_arr_city from f_wide.wide_flight_search_request where dt='20200614')c

on a.qtraceid=c.qtraceid

)t1

left outer join

(select dep_date,arr_city,dep_city,to_date(dep_date) datee,uid from f_wide.wide_order where dt<'20200614' and dt>'20200529')t2

on t1.uid=t2.uid and t1.search_dep_city=t2.arr_city and t1.search_arr_city=t2.dep_city

left outer join

(select dep_date,arr_city,dep_city,to_date(dep_date) datee,uid from f_wide.wide_order where dt<'20200614' and dt>'20200529')t3

on t1.uid=t3.uid and t1.dep_city=t3.arr_city and t1.arr_city=t3.dep_city

where t2.uid is null and t3.uid is null

)t;