Cross join joins for generating two-sheet Cartesian sets

List all two tables. Result table: Column = The number of columns in the original table is added row = The number of rows in the original table is multiplied by the cross join connection is used to generate a Cartesian set of two tables. The use of the Cross join in SQL: 1, the number of records returned is the product of the number of records in a two table. 2. Connect all rows of table A to all rows in table B. Example: TableAr1 r2a BC DtableBr3 r41 4select * from TableA Cross join TABLEB;RETURN:R1 R2 R3 r4r1 R2 1 2r1 R2 3 4 a B R3 R4A B 1 2A b 3 4C D R3 r4c d 1 2C d 3 4

Cross join joins for generating two-sheet Cartesian sets