![]() Of the rows in the result set of the right side. The cross join joins the columns of the rows in the result set of the left side with the columns The cross join forms a cross product of the result set of the left side and the result set of the right The columns on the other side that do not meet the condition sql_cond are filled with OUTER JOIN, at least one row is created in the result set, even if no rows on the other side Row on the left side as LEFT OUTER JOIN or on the right side as RIGHT The difference is that, for each selected The outer join creates the same result set as the inner join. If there are no rows in the result set of the left and right sides that meet sql_cond, no row is created in the resulting result set. Of rows for whose columns the join condition This result set contains all combinations Rows in the result set of the right side into a single result set.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |