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

What is the joins and how many types of Joins in sql server
a diffrentiate ever one give a suaitable query

Question Posted / kamal

2 Answers
6012 Views
Apollo, I also Faced
E-Mail Answers

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

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

112

Is ssrs support other database except ms sql server?

127

What is ms sql server triggers?

942

How to delete all rows with truncate table statement in ms sql server?

929

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1693

List the data types available in mssql?

957

Explain the flow of creating a cube? : sql server analysis services, ssas

1003

How to how to convert numeric expression data types using the convert() function??

989

What is query cost in sql server?

934

What is normalization? Describe its different types.

1040

What are the steps to process a single select statement?

887

What are the tables in sql?

1038

how to use DTS package in 2000,2005,2008 in sql server

1786

Can I work with several databases simultaneously? : sql server management studio

943

Tell me extended events in sql server 2008?

949