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

explain extended properties

927

Describe triggers features and limitations?

926

How can we improve performance by using SQL Server profiler?

984

Which are the two editions in which SQL Azure database available?

117

What is a trigger what are the advantages of trigger?

914

Can we insert data into a view?

1061

How to insert data with null values?

970

What are the steps to insert a table?

892

How to send email from database?

951

What are the different types of join?

1100

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1166

Explain what is public role in sql server?

1058

What is sql server database?

935

Do you know what are the restrictions that views have to follow?

1015

How do you make a trace?

955