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: 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:
Next TopicSQLite Date and Time
|