I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p
if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately
Can anyone help on this?
Answer Posted / ankit sinha
equijoin will produce only the common record.
A right outerjoin B will produce all common records with
remaining records from B . The point to be noticed here is A
is right outerjoined to B which means common records from A
as well as remaining records from B
Opposite things happen with A left outerjoin B
Full outer join means common records and remaining records
from both the tables
crossjoin means multiplications
suppose A has 4 records and B has 4 records.
Total output will have 16 records.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How to use boolean type in select statement?
what are the difference between clustered and a non-clustered index? : Sql dba
What is the difference between clustered and non-clustered indexes?
what is the use of set statement in tsql? : Transact sql
What is a sql profiler?
What is the function that is used to transfer a pl/sql table log to a database table?
What are the various levels of constraints?
What is the difference between numeric and autonumber?
How do you drop a trigger?
how do you know the version of your mysql server? : Sql dba
What is a nested table in word?
What is audit logout in sql profiler?
Define commit?
how can we know the number of days between two given dates using mysql? : Sql dba
Is join and inner join the same?