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

Write a SQL queries on Self Join and Inner Join.

617

What is dirty read?

631

How much memory that we are using in Logshipping Concept?

1368

How to create a Master database in SQL server ?

551

How do I open port 1433?

530

What is a trigger and its types?

541

What are the steps to process a single select statement?

514

What is Extended user-defined?

537

what is a transaction? : Sql server database administration

473

What is difference between Datepart() and Datename() in SqlServer?

722

How can sql injection be stopped? : sql server security

556

What is database white box testing?

680

How to use subqueries with the exists operators in ms sql server?

590

What is sparse columns of sql server 2008?

602

How to enter binary string literals in ms sql server?

584