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
Initializing Objects: Till you initialize an object by calling the constructor for its object type, the object is automatically null. That is, the object itself is null, not me

Logical Operators The logical operators AND, NOT, and OR follow the tri-state logic shown in table below. The AND and OR are binary operators; NOT is a unary operator.

Mutual Recursion The Subprograms are mutually recursive if they directly or indirectly call each other. In the illustration below, the Boolean functions odd & even, that dete

Projection in SQL - correct version Student StudentId is enrolled on some course. SELECT DISTINCT StudentId FROM IS_ENROLLED_ON In more complicated examples it is someti

FETCH Statement The FETCH statement retrieve rows of data one at a time from the result set of the multi-row query. The data is stored in fields or variables which correspond t

INSERT Statement The INSERT statement adds fresh rows of data to the specified database table or view. Syntax:

Consider the schema for FreeChecking Bank, that we designed given below. Translate the given ER schema into SQL CREATE TABLE statements (indicating primary key, unique and foreign

DBMS_PIPE: The Package DBMS_PIPE allows various sessions to communicate over the named pipes. (A pipe is a region of memory used by one of the process to pass information to

Name Resolution In potentially uncertain SQL statements, the names of the database columns take precedence over the names of the local variables and formal parameters. For e.g.

PRIMARY KEY: PRIMARY KEY  indicates that the table is subject to a key constraint, in this case declaring that no two rows in the table assigned to ENROLMENT can ever have the