what is JOIN? Give example & types of join?
Answer Posted / vijay
Join:-
Join are used to retrieve data from more than one
table simultancously .
Types of join are:-
1.Outer join
*--Right Outer join
*--Left Outer join
*--Full Outer join
2.Multiple join
3.self join
4.Inner join
5.cross join
| Is This Answer Correct ? | 18 Yes | 6 No |
Post New Answer View All Answers
Is mysql running ubuntu?
all the queries used in sql
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
What is pragma autonomous_transaction?
How do I copy a table in mysql workbench?
How to get data from mysql in php?
Is mysql free software?
What are the functions in mysql?
What is a csv table?
Why mongodb is faster than mysql?
Explain the difference between mysql and mysql interfaces in php?
How to calculate expressions with sql statements?
How will you export tables as an xml file in mysql?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
What is dirty read and phantom read?