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 / mandayan

not pasible to help u becouse u have to give with data ok

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What's the procedure?

490


How to write a query to show the details of a student from students table whose

540


What is scalar and vector?

528


What is the difference between left outer join and left join?

512


Which is faster count (*) or count 1?

538






How to set up sql*plus output format in oracle?

593


How do I remove duplicates in two columns?

506


What is the basic structure of an sql?

569


what is the difference between cluster and non cluster index? : Sql dba

550


What are the datatypes available in pl/sql ?

609


what are numeric data types? : Sql dba

574


how to use case expression? : Sql dba

549


what is the difference between $message and $$message? : Sql dba

545


What is the sql query to display the current date?

549


What kind of join is join?

555