Definition of cross join - sql, PL-SQL Programming

Definition of CROSS JOIN - SQL

Let s = t1 CROSS JOIN t2, where t1 and t2 are table expressions optionally accompanied by range variables. Then:

Note: Here T denotes Table and R denotes Row

  • The heading Hs of s is the concatenation of the headings of t1 and t2, in that order.
  • If r1 is a row appearing n1 times in t1 and r2 is a row appearing n2 times in t2, then the row formed by concatenation of r1 and r2 in that order appears n1*n2 times in the body of s.

It follows that the degree of the result is the sum of the degrees of the operands and its cardinality is the product of their cardinalities, as with r1 TIMES r2.

Posted Date: 1/18/2013 4:47:57 AM | Location : United States

Related Discussions:- Definition of cross join - sql, Assignment Help, Ask Question on Definition of cross join - sql, Get Answer, Expert's Help, Definition of cross join - sql Discussions

Write discussion on Definition of cross join - sql
Your posts are moderated
Related Questions
UPDATE Command- SQL Loosely speaking, UPDATE changes some of the column values of some existing rows of its target table. Thus, although some rows disappear from the target an


Restriction in SQL Syntax: SELECT DISTINCT StudentId FROM IS_CALLED WHERE Name = 'Boris' The WHERE clause operates on the result of the FROM clause in analogo

which operation is used if we are interested in only certain columns of a table?

Tables within a Table - SQL Figure here is an exact copy of the one in the theory book and as before it is just an alternative way of representing some of the information con

Parameter and Keyword Description: dynamic_string: This is a string variable, literal, or expression which represents a SQL statement or the PL/SQL block. define_vari

Packaging Cursors   You can split a cursor specification from its body for placement in a package. In that way, you can change the cursor body without changing the cursor spec

heap sort program in pl/sql

Parameter and Keyword Description: SQL: This SQL is the name of the implicit SQL cursor. %FOUND: This attribute results TRUE if an INSERT, DELETE, or UPDATE state

Recursion The Recursion is a powerful method for simplify the design of the algorithms. Principally, the recursion means the self-reference. In the recursive mathematical serie