answersLogoWhite

0

Full outer join will fetch at maximum 'addition of 2 tables'

Ex: Table A - 2 rows; Table B - 3 rows.

Full outer join will fetch in 2+3 = 5 rows.

Where as in Cartesian product will fetch in 'product of 2 tables'.

Ex: Table A - 2 rows; Table B - 3 rows.

Full outer join will fetch in 2x3 = 6 rows

User Avatar

Wiki User

11y ago

Still curious? Ask our experts.

Chat with our AI personalities

ViviVivi
Your ride-or-die bestie who's seen you through every high and low.
Chat with Vivi
DevinDevin
I've poured enough drinks to know that people don't always want advice—they just want to talk.
Chat with Devin
LaoLao
The path is yours to walk; I am only here to hold up a mirror.
Chat with Lao

Add your answer:

Earn +20 pts
Q: Difference between cartesian product and full outer join?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Algebra

If the outer diameter of a metal pipe is 2.84 inches and the inner diameter is 1.94 inches the thickness of the metal is?

The answer is the difference between the radii of the inner circumscribed circle and the outer circumscribed circle. The radii equal half of the corresponding diameters; therefore, the thickness is 1/2(2.84 - 1.94) = 0.450 inches, where the last digit is depressed because it may not be accurate within + 1. (The difference between 2.84 and 1.94 has only two significant digits.)


What are the subsets of the universal set are represented in a Venn diagram by what shape a circle an oval or a rectangle?

The universal set is the outer rectangle and all subsets are circles or ovals. In terms of the Venn diagram, there is no difference between circles and ovals.


How do you find wall thickness of pipe knowing the outside diameter and inner diameter of pipe?

Outer radius minus inner radius Subtract the inside diameter from the outside diameter, then divide the difference by 2.


The equation of the inner circle is x2 plus y2 equals 4 the radius of the outer circle is four times the radius of the inner circle write the equation of the outer circle?

The inner circle is x2 + y2 = 4. The radius of the inner circle is the square root of 4, which is 2. To find the radius of the outer circle, multiply 2 times 4. The radius of the outer circle is 8. Square 8 (82 or 8 x 8) to find the number to put into the equation of the outer circle. This is 64. The equation for the outer circle is x2 + y2 = 64.


The two outer terms of proportion?

extremes