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
|