Answer Posted / sheels

Join is used to combin rows from multiple table. Join is performed when ever two or more table is listed in the FROM clause of an SQL statment.
Types of Join;
1.Natural Join: Natural join tells the database to join two table using the common columns.
2.Equality Join: Here the table is related using the equal(=) sign.
3.Inner Join: This is the most common type of join. Inner join returns all the rows from the table when the join condition is met.
4.Outer Join:It joins the matching records from two table and all the records from one side of the table and those un matching records have null value.
(i)Left Outer Join:It joins the matching records from two table and all the records from left side of the table and those unmatching records have null value.
(ii)Right Outer Join: It joins the matching records from two table and all the records from right side of the table and those unmatching records will have null value
5.Self Join: It is used to join a table to it.

What is nested table in pl sql?

1012

---

What are stuff and replace function?

1026

---

What are the two types of periodical indexes?

893

---

what is table? : Sql dba

1002

---

Is sql between inclusive?

1073

---

How does pl sql work?

922

---

what is innodb? : Sql dba

1045

---

Define tables and fields in a database

1086

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

912

---

what is the use of set statement in tsql? : Transact sql

959

---

What are reports usually used for?

980

---

What is the difference between inner join and outer join?

938

---

What is a unique constraint?

1019

---

What are the subsets of sql?

1052

---

Why do we use subquery?

953

---