What is the joins and how many types of Joins in sql server
a diffrentiate ever one give a suaitable query
- 2 Answers
- 5158 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
How you can move data or databases between servers and databases in sql server?
how to avoid cursors? : Sql server database administration
Which are the new data types introduced in sql server 2008?
What is fill factor and pad index?
List the ways in which dynamic sql can be executed?
How to create a Master database in SQL server ?
How to check table values in sql server?
Can we use pragma autonomous_transaction in trigger?
what is a sub-report?
What is reportserver and reportservertempdb ?
What are the requirements to use odbc connections in php scripts?
Explain what are the events recorded in a transaction log?
What are the filtered indexes?
What is co-related sub query?
How to disable a login name in ms sql server?
