Set listobject as ADODB object and use sql on this.

Ok guys,

my macro and code in attachment.

https://paste.ofcode.org/ZqQEnurLTT4q2EcwrG44dy

Now i want to write join on these two recordsets.
Or maybe better is to write left join within only one recordset (rst1?) and not to split tables into 2 separate recordets?

How can i do this?

SQL should work like below:

SELECT rst1.*
FROM rst1 LEFT JOIN rst2 ON rst1.Order= rst2.Order
WHERE rst2.Order Is Null

Please help,
Best,
Jacek