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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / rao

Answer Posted / rao

Using FULLOUTER JOIN

Is This Answer Correct ?    25 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How run sql*plus commands that are stored in a local file?

973

what are aggregate and scalar functions? : Sql dba

992

What is the difference between count 1 and count (*) in a sql query?

906

Can we perform dml on view?

974

How to pipe multiline string to isql?

958

Explain the rollback statement?

961

What are the steps for performance tuning.

1267

What is mutating error?

906

How does left join work in sql?

938

How do you delete a table?

992

How can we link a sql database to an existing android app?

978

List and explain the different types of join clauses supported in ansi-standard sql?

1299

How to read/write files from pl/sql?

991

What is the difference between joins?

974

What are the disadvantages of not performing database normalization?

1091