Answer / sravanthi

The Join keyword is used to query data from 2 or more
tables based on the relationship between the columns in the
table.

1. Join : Returns records when there is atleast one matched
record in both the tables.
2. Left Join : Returns all the records of the left table
irrespective match records in both the tables.
3. Right join : It is just reverse case of left join.
4. Full Join : Returns all the records from both the tables
irrespective matching.

What is the full form of ddl?

0 Answers  

---

New concepts of sql server 2005 use in your project.

0 Answers   TCS,

---

What is sql collation?

0 Answers  

---

Is index a datbase objects in sql server?

2 Answers  

---

How many triggers are possible per table?

0 Answers  

---

If i am handling 150 servers then how to check the active jobs of all the servers?

0 Answers  

---

can we have a nested transaction? : Sql server database administration

0 Answers  

---

What is triggers and its types?

0 Answers  

---

What happens if null values are involved in boolean operations?

0 Answers  

---

What is clustered primary key?

0 Answers  

---

What is Cross Join and in which scenario do we use Cross Join?

0 Answers   QuestPond,

---

What happens if you delete a table that is used by a view?

0 Answers  

---