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 data resources?

911

How do database indexes work?

1009

Can two tables share the same primary key?

916

what is the difference between openrowset and openquery?

1087

How can we delete Duplicate row in table?

1066

Write a sql query to delete duplicate records from a table called table1

1035

Why use triggers?

1014

What is trigger explain with program?

980

What is difference between rownum and rowid?

903

What is the default port for SQL Server over a firewall?

1097

Suggest a method of joining two tables.

1157

What is difference between group by and having?

943

Why is sql server log file full?

1036

What is RMS migrations?

2134

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1033