what is JOIN? Give example & types of join?
Answers were Sorted based on User's Feedback
Answer / santhi mundru
Merging two or three as a single table is called "join"
Types:
Inner Join
Outer Join
right outer join
left outer join
self join.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / santosh
joins are three types
equity join
natural join
conditional joins
these joins use to create conection b\w thie attributes
| Is This Answer Correct ? | 18 Yes | 39 No |
How can an index be declared in mysql?
What is the use of mysql_fetch_array () function in php?
How do I download mysql on my laptop?
What are the 'mysql' command line arguments?
How to install mysql?
What is the use of procedure in mysql?
Is microsoft sql same as mysql?
How to load a csv file into a table
how to declare unique key in creating a table..?
Can you tell a way to know the number of days between the two given dates in php?
How to concatenate two character strings?
How to delete a trigger in mysql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)