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 override dml statements with triggers?

1072

When do you think a developer should use sql server-based cursors?

978

Explain what are magic tables in sql server?

948

When we should use and scope of @@identity?

953

How to create a view on an existing table in ms sql server?

1054

What is subquery in sql?

989

Relational calculus is what type of language?

978

How to change the password of a login name in ms sql server?

963

How can you insert null values in a column while inserting the data?

1213

What is SQL Azure Data sync?

119

A trigger can reference objects outside the current database? State true or false.

948

How to Check if table exists in sql server?

1075

Is mysql the same as sql server?

914

Can we use pragma autonomous_transaction in trigger?

912

What are locks in sql?

934