Query to see updates between two tables

[Undo]

Hello

I have a sample sheet with "Past table", "Today table" and I am looking to have new query that display the missions from last two tables that "Start update" (exist in first table and removed from second) and "End update" (exist in second and not in first) and don't display the mission that exist in two tables (mean is running - so no updates)

note: that sample based on today date : 16 March
looking for smallest and fastest QUERY steps

Thanks in advance

[sandy666]

something like this?

PAST Table
Uniqe Key	MISSION	FROM	TO
234	A66	01/03/2023	20/03/2023
430	D44	12/03/2023	15/03/2023
TODAY Table
Uniqe Key	MISSION	FROM	TO
234	A66	01/03/2023	20/03/2023
430	D44	12/03/2023	15/03/2023
55	T1	16/03/2023	19/03/2023
Uniqe Key	MISSION	FROM	TO
55	T1	16/03/2023	19/03/2023

[Undo]

Thanks we are almost there
uniqe id 430 must appear in updates query (I forget to delete it from second file, but I delete it now and refresh query still not appear)
and one new column in updates query "update" end/start

[sandy666]

check this one

[Undo]

Thank you its working, but a lot of queries
I am looking for less querys/steps (for fast refreshing)
I think it can be done with 3 querys (past-today-updates)

looking for more
Repuatation Added

[sandy666]

try, try, try and maybe you'll get lucky

it can be done with one query (collapse all queries into one et voilà!)

[Undo]

To be more simple

the idea is append two tables, then remove duplicated column "unique key" (don't keep any row that was duplicated with another row) - so its not normal remove duplicatedd step
I think this the fastest steps to get the result
any help/idea..