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

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1222

How can we check the sql server version?

1125

How can you list all the table constraints in a database?

980

List the data types available in mssql?

1102

Does windows server 2016 come with sql server?

986

Can you explain what is the use of custom fields in report?

1099

Explain the types of indexes.

1294

Can we use max in where clause?

983

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1100

what is a correlated sub-query? : Sql server database administration

992

What should be the fill factor for indexes created on tables? : sql server database administration

1177

What do you need to connect php to sql server?

1153

What are rows and columns?

1064

What are the tools available in market as an alternative to sql server reporting services?

138

Explain in brief about Microsoft SQL server?

1173