What are inner join and outer join?

Answer Posted / omprakash.jsm

Inner join return rows from many tables where the join field and data type are equal.

outer join return rows from many tables where the join field are not equal but data type will be same.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain database link?

651


What is coalesce function?

565


What is an index associated with a constraint?

545


Explain index?

733


Query to retrieve record for a many to many relationship ?

2075






What is a tns file?

495


What are the different pseudo commands? Explain in general?

537


How to retrieve values from data fields in record variables?

557


What is execute immediate in oracle?

541


What are named parameters?

606


What is the difference between sharding and replication?

473


How to experiment a data lock in oracle?

590


What do you mean by group by clause?

549


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1766


Which is better Oracle or MS SQL? Why?

5420