its depend on join what type join you are using,If You are using cross joi

How maney row would be print after join if A table have 100
rows and B table have 50 rows...

Question Posted / brajesh kumar srivastava

Answer Posted / brajesh kumar srivastava

its depend on join what type join you are using,If You are
using cross join then 100*50 record would printed.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you please explain the difference between function and stored procedure?

1008

What are the different types of subquery?

1160

What is etl - extraction, transformation, and loading?

919

What is a trigger and its types?

991

Explain syntax for viewing, dropping and disabling triggers?

953

Difference between DELETE and TRUNCATE?

1050

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

909

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

150

Explain mixed authentication mode of sql server?

1065

What are sql server functions?

987

Explain about system stored procedure?

1035

What is the return type of executeupdate ()?

907

What are the reporting services components?

142

What is filestream?

1002

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1066