SQL POSITIONAL Join (DuckDB, ClickHouse)

The POSITIONAL (DuckDB) or PASTE (ClickHouse) join is great for "gluing" two tables together, side-by-side. This isn't available in most databases, primarily because it doesn't "make sense" to include in them. For a database like DuckDB, however, this can be super helpful for combining other file types like CSVs and Parquet files which do have a natural order. - https://duckdb.org/docs/sql/query_syntax/from#positional-joins --------------------------------------------------- This is part of the Everything About Joins playlist, available at: - https://www.youtube.com/playlist?list=PLEiRgvTilK5rJilO6gc809Eg2Qajgeh02 The written version of this content is also available at: - https://billwallis.github.io/sql-learning-materials/everything-about-joins/syntax/glue-joins/ --------------------------------------------------- CHAPTERS 00:00 Intro 00:52 Simple example (DuckDB) 02:56 Simple example (ClickHouse) 03:42 A real example 07:20 Alternative approaches 09:42 SQL tables aren't ordered 13:22 Wrap up