How to Join Two Tables Without a Relationship Using SQL Cross Joins in PostgreSQL

Left Joining Twice on the Same Table with Multiple IDs Using SQL and Common Table Expressions (CTEs)