the result will depend upon the type of join it carry 150 rows if its a ful

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

Question Posted / ankit misra

Answer Posted / ankit misra

the result will depend upon the type of join it carry 150 rows if its a full outer join,it will carry common rows if its a natural join.

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is extended stored procedures?

573

How do you test your database? : sql server database administration

528

Does index speed up select statements?

588

List all types of constraints in sql server?

520

What is @@rowcount in sql?

566

How to see existing views in ms sql server?

551

Which autogrowth database setting is good?

619

Tell me what are the essential components of sql server service broker?

512

How to convert a table data in XML format in sql server?

2124

What are Row versions of DataRow?

611

Define Joins?

614

How to add additional conditions in SQL?

590

How to use subqueries in the from clause in ms sql server?

571

How to create a new schema in a database?

555

why would you use sql agent? : Sql server database administration

531