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

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

Answer Posted / rizaul

I have used inner joins

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is blind sql injection?

992


how to present a past time in hours, minutes and seconds? : Sql dba

946


How to process query result in pl/sql?

1062


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

951


What is sql injection vulnerability?

872


List the different type of joins?

1003


How many types of literals are available in pl sql?

1047


What are the types of keys?

935


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1006


what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

946


What is difference between pls_integer and integer?

910


Does sql require a server?

944


What is difference between function and trigger?

972


Which operator is used in query for pattern matching?

1034


Define sql delete statement.

955