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

Explain the usage of floor function in sql server.

1018

How do I view a procedure in sql server?

1036

What is table join?

1172

What is the library index called?

1109

How real and float literal values are rounded?

1200

What is the difference between clustered and non-clustered indexes in ms sql server?

1051

Can I work with several databases simultaneously? : sql server management studio

1029

Explain in details security in SQL azure?

123

What type of Index will get created after executing the above statement?

1144

What does <> symbol mean?

1026

How much memory that we are using in Logshipping Concept?

1844

Why I am getting this error when dropping a database in ms sql server?

1119

Can the query output be sorted by multiple columns in ms sql server?

1028

What is the difference between left and right outer join?

1112

List the advantages of using stored procedures?

1106