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 method is used by the Command classes to execute SQL statements that return single values?

1057

What's new in sql management studio for sql server? : sql server management studio

1059

New concepts of sql server 2005 use in your project.

2354

What is the difference between functions and stored procedures?

1153

What are sql azure firewall rules?

106

What types of Joins are possible with Sql Server?

1116

What is 2nf normalization?

1013

What do you understand by replication in sql server? Mention the different types of replication in sql server.

939

Explain microsoft sql server functions?

1102

Explain how you can configure a running aggregate in SSRS?

163

What do you understand by mirroring and mention the advantages of the mirroring?

1058

How we can compare two database data?

935

How do I view a script in sql server?

1033

Explain about link server in sql server?

1050

What is coalesce and check constraint in sql server?

1109