Interested to Buy Any Domain ? << Click Here >> for more details...
how to join two table?
- 2 Answers
- 5060 Views
- iNautix, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / partha
There are two types of join inner join and outer join.
(1)Inner join will return all the common records in both the
table
Ex: Select e.ename from Employee e,Dept d where e.did=d.did;
(2)Outer join is of 3 types Left Outer,Right Outer and full
outer.
Left outer retrieves common records from both the table and
all the record from the left table.
Similarly Right Outer all the records from right table and
Full outer from both the tables
| Is This Answer Correct ? | 21 Yes | 0 No |
What is openedge translation manager?
How to monitor firebird server activity?
What are the steps to follow when preparing to create a table?
What is the use of OWNER option in EXP command ?
Define entity, entity type, and entity set.
How to use multiple database server in back end ?
How is data stored in a relational database?
Operators used in select statements are?
Mention the different languages present in dbms
How to do replication of firebird databases?
What is data model in database?
Why do we study dbms?
-
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)
