Skip to content
Advertisement

Clean way to construct cartesian joins in BigQuery (SQL)

I have multiple lists, and I want to construct cartesian joins of these lists using SQL. I’m wondering if you know a cleaner method than the one below. Thanks

Advertisement

Answer

Your query looks fine, but there is no reason to use CTEs:

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement