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

How will you make an attribute not process? : sql server analysis services, ssas

1027

How to disable a login name in ms sql server?

1074

Explain temporary table vs table variable by using cursor alternative?

951

What stored by the tempdb ? : sql server database administration

1017

What is Cross Join and in which scenario do we use Cross Join?

984

What is the difference between dropping a database and taking a database offline?

1126

How to write an inner join with the where clause in ms sql server?

1042

Do you know what is a linked server in sql server?

978

What is a system database and what is a user database?

1034

What is #table in sql server?

1010

What is 'Join' and explain its various types.

1077

What is row_number () and partition by in sql server?

1021

Can we add a cpu to sql server?

971

How to execute a stored procedure in ms sql server?

1092

Is sql different from sql server?

1016