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 form and report?

926


What is cursor and its types?

994


Does truncate need commit?

893


What is a trigger word?

961


What are different types of sql commands?

1024


What operating systems are supported by oracle sql developer?

903


What is AUTH_ID and AUTH_USER in pl/sql ?

2137


What are user defined functions?

947


How to connect a sql*plus session to an oracle server?

1080


How do I filter in sql profiler?

948


What is pl sql package?

991


What is sql profiling in oracle?

995


what are the non-standard sql commands supported by 'mysql'? : Sql dba

1043


What do you think about pl/sql?

948


What is oracle sql called?

863