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

what is JOIN? Give example & types of join?

Answer Posted / naveen

when data from more than one table in the database is
required,a join condition is used.
select empno,ename,dname,loc from emp,dept;
equi join
non-equi join
self join
outer join
cartesian join

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does mysql workbench do?

812


What is bigint in mysql?

865


How does mysql store dates?

877


What is mysql database extension?

963


What is difference between mongodb and mysql?

868


What is the data type for file in mysql?

922


How to shut down the server with 'mysqladmin'?

916


What storage engines are used in MySQL?

982


What are date and time data types in mysql?

954


How to dump a table from a database.

961


Do you need a license for mysql?

894


How do I transfer data from one database to another in mysql?

853


What is dblink?

829


How do I start mysql in ubuntu?

955


How do I stop a query in mysql workbench?

862