Answer Posted / glibwaresoftsolutions

• Inner Join: Returns matching rows from both tables.
• Left Join (Left Outer Join): Returns all rows from the left table and matching rows from the right table.
• Right Join (Right Outer Join): Returns all rows from the right table and matching rows from the left table.
• Full Join (Full Outer Join): Returns all rows when there’s a match in one of the tables.
• Cross Join: Returns the Cartesian product of both tables.
• Self Join: A table joins itself.
Example Query:
SELECT e1.name, e2.name AS manager_name
FROM employees e1
JOIN employees e2 ON e1.manager_id = e2.id;

Is oracel sql developer written in java?

1108

---

Why use subqueries instead of joins?

1081

---

which tcp/ip port does sql server run on? : Sql dba

1026

---

what are the types of subquery? : Sql dba

1105

---

What is transaction control language (tcl)?

1139

---

What is partition in sql query?

998

---

How do I write a cron which will run a sql query and mail the results to agroup?

981

---

What is t-sql? : Transact sql

987

---

How do I send sql query results to excel?

1066

---

What is cursor explain with example?

986

---

Is left join faster than join?

1053

---

Is sql dba a good career? : SQL DBA

992

---

Explain what is a field in a database and record in a database?

1097

---

what are the different tables present in mysql? : Sql dba

984

---

What is sql table?

972

---