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 to fetch common records from two tables?

Answer Posted / mrityunjay dubey

Select column_name from tableA UNION Select column_name from tableB

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of & in pl sql?

1046


discuss about myisam index statistics collection. : Sql dba

952


How do you write a subquery?

1029


Mention what does plv msg allows you to do?

1124


what is bdb (berkeleydb)? : Sql dba

1034


what tools available for managing mysql server? : Sql dba

1085


How do you drop a trigger?

992


what is meant by urlencode and urldocode? : Sql dba

1176


What is a record in pl/sql?

1148


what is sp_pkeys? : Transact sql

1159


Is sqlite good enough for production?

992


Write a sql query to convert all character to uppercase after hypen.

1438


How to display the current date in sql?

1077


What is an inconsistent dependency?

1046


What is anonymous block in sql?

1120