actually it is natural join.if two table is there like A and B the natural

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

Question Posted / rajesh kannan.m

Answer Posted / rajesh kannan.m

actually it is natural join.if two table is there like A and B
the natural join is A*B.A=100,B=50.so ans is 100*50=5000 rows.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is datawarehouse?

1074

What are the different types of Indexes available in SQL Server?

966

Why use cursor in sql server?

1024

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

861

What is the language structure to add a record to a table?

988

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1006

Which table keeps information about stored procedures?

900

What is BCNF? How is it better than 2NF & 3NF?

983

What is a join in sql?

1046

What is the architecture of ms sql reporting service?

942

What do you understand by user-defined function in the sql server?

918

What are the advantages of using stored procedures?

907

What is nested transaction?

1062

How to loop through result set objects using mssql_fetch_array()?

1040

What is the difference between index seek vs. Index scan?

984