5*2=10 Its a cartesian product

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 / sirisha

Answer Posted / sirisha

5*2=10
Its a cartesian product

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the difference between rename and alias?

1021

What is database migration?

973

How many primary keys can a table have?

1017

Does mysql support pl sql?

1181

What are conditional predicates?

1064

What is a full join?

997

what are enums used for in mysql? : Sql dba

1176

what is a relationship and what are they? : Sql dba

1110

What is optimistic concurrency control? : Transact sql

990

Is natural join same as inner join?

951

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2024

How is debugging done?

989

What is the command used to fetch first 5 characters of the string?

1407

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1230

What is difference between nchar and nvarchar?

1037