which type of inner join fetches result with redundant data??
Answers
Answered by
0
This can be represented by two tables by two sets A and B.
On the off chance that we discuss inward join then it contains the consequences of A and B.
Equi Join is a kind of inward join which gives redundant information.
How about we comprehend by an illustration.
May there be two tables:
Customer(CustID, CustName) and Order(CustID, date, sum)
Equi join is done in the following way:
SELECT *
FROM Customer JOIN Order
ON Customer.CustID = Order.CustID
This will bring about a table with columns (CustID, CustName, CustID, date, amount)
In the outcome, CustID shows up twice and it will contain indistinguishable information. Subsequently, the outcome has redundant information.
There is one more internal join called NATURAL JOIN, which doesn't contain this redundancy in its outcomes.
On the off chance that we discuss inward join then it contains the consequences of A and B.
Equi Join is a kind of inward join which gives redundant information.
How about we comprehend by an illustration.
May there be two tables:
Customer(CustID, CustName) and Order(CustID, date, sum)
Equi join is done in the following way:
SELECT *
FROM Customer JOIN Order
ON Customer.CustID = Order.CustID
This will bring about a table with columns (CustID, CustName, CustID, date, amount)
In the outcome, CustID shows up twice and it will contain indistinguishable information. Subsequently, the outcome has redundant information.
There is one more internal join called NATURAL JOIN, which doesn't contain this redundancy in its outcomes.
Similar questions