what @simeon posted above is what I use regularly to compare data between two tables.
Regarding your question on why it is not displaying the results, it could be because its just running the CTEs , we would need to execute the sqls to display the results,for which you can use EXECUTE IMMEDIATE
like shown here