What is the difference between various types of joins? For instance, there's inner join, left join, right join, full join, cross join, natural join, equi-join, and semi-join? - Quora
SQL CROSS JOIN - Overview with Examples
SQL CROSS JOIN with examples
SQL CROSS JOIN with examples
Cartesian Product vs Full Outer Join in SQL Server” | by Smita Gudale | Medium