how to join two table?
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 |
How to extract metadata for the entire database?
What is database Configuration assistant ?
What do you understand by data model?
What is a logical backup ?
What are the benefits of database?
What do you know about DBMS?
Define denormalization.
What type of file is used for porting Forms 4.5 applications to various platforms?
What do you mean by starvation in dbms?
What do you mean by query evaluation engine?
Can you copy the PROGRAM UNIT into an Object group ?
Where is data stored in database?
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)