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 do I assign a variable in mysql?
What are the mysql database files stored in system ?
What is the data type for file in mysql?
What is latest version of mysql?
What is the difference Delete and Drop ?
How do I setup a mysql database?
What is procedure in mysql?
How to use mysqldump to create a copy of the database?
Why do we use group by and order by function in mysql?
What is the difference between myisam dynamic and myisam static in mysql?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
How do you convert to a different table type?
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)