Skip to content

CROSS JOIN is not supported although being a valid SQLite syntax operator #2621

@hugonoro

Description

@hugonoro

Describe the bug
CROSS JOIN doesn't seem to be supported, triggering a syntax error for not recognising the operator

Database Engine
SQLite

To Reproduce
Write any simple SQLite query including CROSS JOIN

e.g SELECT column_name(s) FROM table1 CROSS JOIN table2;

Expected behavior
This command will return a result set that includes every combination of rows from both tables involved in the join

Screenshots
N/A

Additional context
N/A

Metadata

Metadata

Assignees

Labels

duplicateThis issue or pull request already exists

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions