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

UNION ALL

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why truncate is faster than delete?

1088


How do you go back in sql?

973


What is pl sql in oracle?

1021


Explain ttitle and btitle.

1104


how to extract a unit value from a date and time? : Sql dba

978


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

977


What is vector point function?

1026


What is not equal in sql?

1084


1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1579


Explain the order of sql statement execution?

1026


How many sql statements are used? Define them.

1017


What does sign mean sql?

1071


What is the purpose of design view?

994


How to find 3rd highest salary of an employee from the employee table in sql?

1060


How to run pl/sql statements in sql*plus?

1059