Answer Posted / kamal

/* INNER JOIN -- Matched Rows only from Tables */
SELECT NR.RequestId, U.UserId FROM ITWP_NewRequest NR

INNER JOIN ITWP_Users U ON U.UserId = NR.UserId

/* OUTER JOIN -- Matched Rows only from Tables
RIGHT OUTER JOIN -all the rows from Right table and matched
rows from Left Table.

LEFT OUTER JOIN - all the rows from Left table and matched
rows from Right Table.

FULL OUTER JOIN - all the rows from Left table and from
Right Table.
*/
SELECT NR.RequestId, U.UserId FROM ITWP_NewRequest NR

RIGHT OUTER JOIN ITWP_Users U ON U.UserId = NR.UserId

SELECT NR.RequestId, U.UserId FROM ITWP_NewRequest NR

LEFT OUTER JOIN ITWP_Users U ON U.UserId = NR.UserId

SELECT NR.RequestId, U.UserId FROM ITWP_NewRequest NR

FULL OUTER JOIN ITWP_Users U ON U.UserId = NR.UserId

/* A Join without having any condition is known
as Cross Join, in cross join every row in first table is
joins with every row in second table.
*/
SELECT NR.RequestId, U.UserId FROM ITWP_NewRequest NR

CROSS JOIN ITWP_Users U

explain different types of joins? : Sql server database administration

1035

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2276

---

How to create hyperlink from returned sql query ?

1183

---

How do I view a script in sql server?

1088

---

Does sql server use java?

1127

---

Explain the dirty pages?

1050

---

Define left outer join in sql server joins?

1011

---

What is the maximum size of a row in sql server?

1006

---

What are the options which must be set to allow the usage of optimistic models?

1020

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1200

---

What is cursors?

1261

---

Characterize join and name diverse sorts of joins?

1022

---

what stored procedure can you use to display the current processes? : Sql server administration

1057

---

What sql server means?

1007

---

How to enable/disable indexes?

1123

---