IF TWO TABLE A(100) AND B(50) ARE PARTICIPATE IN NO SPECIFIC JOIN THEN IT

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

Question Posted / tnt

9 Answers
11469 Views
Hewitt, I also Faced
E-Mail Answers

Answer Posted / tnt

IF TWO TABLE A(100) AND B(50) ARE PARTICIPATE IN NO
SPECIFIC JOIN THEN IT WILL BE CROSS JOIN LIKE THIS

SELECT A.ROW,B.ROW FROM A,B

IT WILL GIVE 100*50 RESULT

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What security features are available for stored procedure?

990

Mention what are the different types of ssrs reports?

144

can you instantiate a com object by using t-sql? : Sql server database administration

963

What are various aggregate functions that are available?

917

What is row-level compre?

944

Explain what are various ways to enhance the ssrs report?

993

Can a rule be bound to any column of any data type?

913

How can i Relate Tables in SSIS

1036

what are the Prerequisites for Replication?

11242

What is failover clustering overview?

1023

How to truncate the log in sql server 2012? : sql server database administration

1201

What is the difference between sdf and mdf?

1234

what's the difference between delete table and truncate table commands? : Sql server database administration

923

How to integrate the ssrs reports in application?

936

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1069