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 |
What is append query?
How can I create a database in mysql?
what if you really want to store the timestamp data, such as the publication date of the article?
What are the different tables present in MySQL?
How can we find the number of rows in a table using MySQL?
How does mysql clustering work?
Differentiate CHAR_LENGTH and LENGTH?
how fastest access of data can be done from database ?
What is processlist in mysql?
how to know the tables in database having foreign key?
What is identity in mysql?
How do you prevent MySQL from caching a query?
Oracle (3259)
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)