Select * from (
Select Anderson d as aa, b.i d as bb from
(
Select the id from temp. Ods_ecs
) a
Left the join
(
Select id from temp. Ftp_ecs where dt='2021-01-11'
B)
On Anderson, d=b.i d
C where bb is null


How to obtain Anderson d less than the b.i d several data information, please break down

CodePudding user response:

Right join