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 does stored procedure reduce network traffic?

547

What is oracle pl sql developer?

532

What is the main difference between sql and pl/sql?

567

What are local and global Indexes and where they are useful.

930

what are the 'mysql' command line options? : Sql dba

557

What is union, minus and interact commands?

750

What are different methods to trace the pl/sql code?

544

What found sql?

528

how to shut down the server with 'mysqladmin'? : Sql dba

549

What is the file extension for sql database?

519

What does the hierarchical profiler does?

570

What is sqlca in powerbuilder?

572

how to concatenate two character strings? : Sql dba

556

What are triggers and its types?

555

what is data integrity? : Sql dba

596