It creates a set that can be saved as a table or used sql the good parts pdf it is. If the evaluated predicate is true, the combined row is then produced in the expected format, a row set or a temporary table.
For example, a Department may be associated with a number of Employees. Joining separate tables for Department and Employee effectively creates another table which combines the information from both tables. All subsequent explanations on join types in this article make use of the following two tables. The rows in these tables serve to illustrate the effect of different types of joins and join-predicates. Note: In the Employee table above, the employee “Williams” has not been assigned to any department yet.
Also, note that no employees are assigned to the “Marketing” department. This is the SQL statement to create the aforementioned tables. In other words, it will produce rows which combine each row from the first table with each row from the second table. The cross join does not itself apply any predicate to filter rows from the joined table.