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 |
Should I use pdo or mysqli?
How do you create a new database in mysql?
what are the different tables present in mysql? : Mysql dba
What are aggregate functions in mysql?
How do I change global variables in mysql?
How do I grant privileges to a user in mysql phpmyadmin?
What does do in mysql?
What does mysqli stand for?
why not null is not allowed at table level
How do you rename a procedure in mysql?
How to decrement dates by 1 in mysql?
Explain csv tables.
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)