Concept of cross join the result will be 10 bcos 5*2 = 10

there is A table and B table in A table there 5 rows and in
b table there are 2 rows i am firing query select * from
a,b what will be the output?

Question Posted / dharmendra singh

Answer Posted / dharmendra singh

Concept of cross join
the result will be 10 bcos 5*2 = 10

Is This Answer Correct ?

9 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is compound trigger?

964

Can I join the same table twice?

996

Does asenumerable execute the query?

987

Why do we use joins?

986

What is crud diagram?

880

What is the difference between numeric and autonumber?

942

Can we use commit inside a trigger?

1030

What is the difference between a subquery and a join?

1014

What can I use instead of union in sql?

905

What is number function in sql?

915

what is sql? : Sql dba

973

Explain the difference between drop and truncate commands in sql?

965

What is the difference between count 1 and count (*) in a sql query?

911

What is sql exception?

915

what is the difference between sql and t-sql? : Transact sql

1043