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

How much does a sql dba make? : SQL DBA

506

What is native sql query?

546

What is tuple in sql?

541

Can we edit a view in sql?

544

What is sql injection owasp?

546

What are crud methods?

549

define join and explain different type of joins? : Sql dba

544

What is exit statement?

542

how many triggers are allowed in mysql table? : Sql dba

556

Why indexing is needed?

516

What is dbo in sql?

533

What is composite data type in pl sql?

554

What is %type in pl sql?

540

Which is better cte or subquery?

540

Is a secondary key the same as a foreign key?

488