C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
SQLite Cross JoinThe SQLite Cross join is used to match every rows of the first table with every rows of the second table. If the first table contains x columns and second table contains y columns then the resultant Cross join table will contain the x*y columns. Syntax: SELECT ... FROM table1 CROSS JOIN table2 Image Representation: We have two tables "STUDENT" and "DEPARTMENT". The "STUDENT" table is having the following data: The "DEPARTMENT" table is having the following data: Example: Select all records from tables STUDENT and DEPARTBMENT after cross join: SELECT * FROM COMPANY CROSS JOIN DEPARTMENT;
Next TopicSQLite Date and Time
|