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

Is mariadb nosql?

1093

How do you concatenate in sql?

1086

How to get help at the sql prompt?

1166

What is a ddl command?

1157

Can a primary key be a foreign key?

1081

What are crud methods?

1086

what is the difference difference between procedure and packages

10549

Which one is faster ienumerable or iqueryable?

991

What is record type in pl sql?

1036

How does sql store data?

959

What are records give examples?

1054

what is datawarehouse? : Sql dba

1066

what is blob? : Sql dba

1222

What are the uses of sysdate and user keywords?

1151

How many types of triggers exist in pl/sql?

1137