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...

How do you get all records from 2 tables. Which join do you use?

Answer Posted / vinay

use full outer join you can get the records

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does plv msg allows you to do?

1125


What are different types of sql?

1161


What is the difference between sum and count in sql?

975


What is primary key and foreign key?

948


How do I count rows in sql query?

976


What is difference between pl and sql?

1037


What are the string functions in sql?

962


In pl/sql, what is bulk binding, and when/how would it help performance?

983


What is the most common sql injection tool?

1030


Does sql profiler affect performance?

979


Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1125


When sql appeared?

1075


What is the use of index in hive?

992


How to use transactions efficiently : transact sql

1036


What does partition by mean in sql?

949