| What is output of below query one have 10 records and other have 5 records in a table?
select * from table1, table2
Answer:-When we run above query if we have 2 tables one have 10 records and other table have 5 records it will produce cartesain product of two tables or we can say it will produce cross join. So total number of records will be displayed are 50 records. | | |