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 are analytical functions in sql?

1038

how to load data files into tables with 'mysqlimport'? : Sql dba

1103

Can we rollback after truncate?

1035

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3577

Is there a way to automate sql execution from the command-line, batch job or shell script?

978

How to use distinct and count in sql query? Explain

1035

What is the need of a partition key?

991

Why cross join is used?

1084

Can a foreign key be null?

1093

What is a data manipulation language?

1029

Explian rowid, rownum? What are the psoducolumns we have?

1008

How do I know if I have sql express or standard?

1043

What are database links used for?

1052

How to set up sql*plus output format in oracle?

1044

Is sql open source?

980