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 to dump all databases for backup. Backup file is sql commands to recreate all db's.
What is a select query?
How do I delete a table in mysql workbench?
What do ddl, dml, and dcl stand for?
How to connect html form to mysql database using php?
How do I install mysql workbench?
what is the difference between between and in operators in mysql?
Is mysql owned by oracle?
Why do gaps in sequences occur?
What is view? How can you create and drop view in mysql?
How do I connect to mysql database?
How many values can the SET function of MySQL take?
2 Answers Creative Informatics,
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)