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

What are different types of subquery?

1232

Some queries related to SQL

976

What are rest-style architecture's?

170

How to call a function from a stored procedure in SQL Server ?

1016

on line cluster can we make if yes tell me the procedure

2012

How to write a query with an inner join in ms sql server?

1035

What is the maximum length of an alert name?

999

What is the difference between primary key and unique constraints?

950

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1188

Why do you need a sql server?

1097

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

955

Can we use custom code in ssrs?

1105

What is use of except clause? How it differs from not in clause?

1017

How to get @@error and @@rowcount at the same time?

1024

How to get the definition of a view out of the sql server?

983