Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 7328 Views
- I also Faced
- E-Mail Answers
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
Is left join inner or outer?
How much does sql certification cost?
how to add a new column to an existing table in mysql? : Sql dba
How do you delete data from a table?
Can we use ddl statements in stored procedure sql server?
How can you save or place your msg in a table?
What is the starting oracle error number?
What are sql functions? Describe the different types of sql functions?
What are the types of sql commands?
What is delimiter sql?
what is commit? : Sql dba
How to write pl sql program in mysql command prompt?
What is a data manipulation language?
Which certification is best for sql?
What is the difference between unique and primary key constraints?
