/* 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
6183 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

What is database black box testing?

1034

What do you think of this implementation? Can this be implemented better?

945

How do triggers work?

941

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

990

Can we perform backup restore operation on tempdb? : sql server database administration

999

difference between Clustered index and non clustered index ?

993

What is failover clustering overview?

1090

What are the differences between sql server and mysql.

1099

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1125

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

918

What are the authentication modes in sql server? How can it be changed?

1130

Explain datetimeoffset data type in sal server 2008?

910

Can we return Data from 4(more than 1) tables in stored procedure?

1059

How to delete duplicate rows from table except one?

990

What is database mirroring?

1118