it returns common records between table A and table B, because if we use on

How maney row would be print after join if A table have 100
rows and B table have 50 rows...

Question Posted / saurav kumar

Answer Posted / saurav kumar

it returns common records between table A and table B, because if we use only join it behaves as a inner join in SQL Server

Is This Answer Correct ?

26 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I find the sql server version?

1029

What is 3nf normalization form?

1121

How can we migrate from SQL server to SQL Azure?

113

Explain the purpose of indexes?

983

Explain “row_number()” in sql server with an example?

1010

Can we use custom code in ssrs?

1120

Can we call stored procedure in trigger?

953

How can you check the level of fragmentation on a table?

1049

What is subquery in sql?

1074

What is a Join and explain its types?

1106

Which are new data types introduced in sql server 2008?

1057

What is the security principal at the database level that represents your session?

946

How to delete exactly duplicate records from a table?

1067

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1024

Explain a differential backup?

1015