Answer:
when a join condition is omited when getting result from two tables then that kind of query gives us Cartesian product, in which all combination of rows displayed. All rows in the first table is joined to all rows of second table...
Hope this answer helps!
Inclus - We provide individual and corporate training
Educate, Learn & Serve
Chat with our AI personalities
The cartesian coordinates are plotted on the cartesian plane
what are the parts of the Cartesian plane ?
ANSI SQL is the American National Standards Institute standardized Structured Query Language. ANSI SQL is the base for several different SQL languages such as T-SQL and PL/SQL. ANSI SQL is used to Create, Alter, and View data stored within a database. For more information about ANSI: http://www.ansi.org/ For more information about SQL: http://en.wikipedia.org/wiki/SQL
René Descartes - hence cartesian
it means cross product. so if you have 3 male and 2 female, how many couple combination we can have. 2 X 3 = 6.