It gives a cartesian product or a cross 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 / manda

Answer Posted / manda

Is This Answer Correct ?

11 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is bcp? When is it used?

1049

Are subqueries better than joins?

922

What does pl sql stand for?

1065

How many scalar data types are supported in pl/sql?

978

What are sql functions? Describe the different types of sql functions?

1060

what is a field in a database ? : Sql dba

991

Define commit, rollback and savepoint?

979

Which nosql database is best?

928

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

988

Can I join the same table twice?

996

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

944

What is sql performance tuning?

868

What are the differences between in and exists clause?

1050

Explain the commit statement.

1103

How many types of indexes are there in sql?

935