It is concept of CROSS JOIN.. It will display 5 * 2 = 10 rows

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 / santosh pashte

Answer Posted / santosh pashte

It is concept of CROSS JOIN..

It will display 5 * 2 = 10 rows

Is This Answer Correct ?

41 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the difference between distinct and unique in sql?

989

What is flag in sql?

1097

What is dba in sql? : SQL DBA

1092

What are the different operators available in sql?

1057

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1064

what is the use of set statement in tsql? : Transact sql

1059

Can a table contain multiple foreign key’s?

1049

Why do we use sql constraints?

1212

Determine if oracle date is on a weekend?

1087

What is execution plan in sql?

1089

is mysql query is case sensitive? : Sql dba

1162

what is self-join? : Sql dba

1236

Differentiate between sga and pga.

1206

How many tables can a sql database have?

1026

What is pl sql block in dbms?

1054