Cross join In DB

[simonaubert_bd]

Hello all,

According to wikipedia :
https://en.wikipedia.org/wiki/Join_(SQL)

CROSS JOIN returns the Cartesian product of rows from tables in the join. In other words, it will produce rows which combine each row from the first table with each row from the second table.[1]

Example of an explicit cross join:

SELECT *
FROM employee CROSS JOIN department;

Example of an implicit cross join:

SELECT *
FROM employee, department;

The cross join can be replaced with an inner join with an always-true condition:

SELECT *
FROM employee INNER JOIN department ON 1=1;

For us, alteryx users, it would be very similar to Append Fields but for in-db.

Best regards,

Simon

[KylieF]

Thank you for your idea!

We appreciate the insight on what kind of new functionality our users would like to see out of our In-DB tools. If you haven't be sure to share this idea with any users you think would benefit from this kind of update as it's always helpful to hear use cases on how users would use this feature to gauge interest.

[simonaubert_bd]

Well, it's even available on Dataiku..

[simonaubert_bd]

Cross join, implemented in ANSI SQL 1992... maybe because it's useful.