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 to update a field in SQL after ALTERING a row?

1286

Explain powershell included in sql server 2008?

1114

What are the types of database recovery models?

1186

How to return the second 5 rows in ms sql server?

1106

What are the different types of sql server replication? : sql server replication

1367

What is cached report?

150

What are the lambda triggers?

956

How many columns can exist together per table?

1207

What is the difference in accessing db between sql server vs sql azure?

174

What is trace flag in sql server?

1078

How do we know if any query is retrieving a large amount of data or very little data?

1032

What is 3nf normalization form?

1168

What are the properties of the transaction?

1052

Describe the left outer join & right outer join. : sql server database administration

1037

what is the maximum size of a row? : Sql server database administration

1080