Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is meant by raw datatype?

1054


What is the usage of merge statement?

1141


How to use windows user to connect to the server?

986


Explain drop constraint oracle?

1051


what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2262


What is the usage of save points in oracle database?

960


can anyody please send me the dump for Oracle 10g certifications for DBA path?

2118


How to drop an index?

950


How many anonymous blocks can be defined?

1177


What are the attributes of cursor?

1045


What is an oracle function?

1150


How to connect to oracle using service name instead of sid?

1012


How can we view last record added to a table?

1034


How to assign query results to variables?

1044


I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1101