I want to display a result query from joining two tables with 20 and 10 rows respectively. Erroneously I forget to write the WHERE clause. What would be the result?

Started by Daanish, March 21, 2016, 10:37:58 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

Lorenzo

March 21, 2016, 10:37:58 AM Last Edit: April 22, 2017, 01:03:56 PM by Sofyene
Hello, I have a little problem that I can not answer, i want to display a result query from joining two tables with 20 and 10 rows respectively. erroneously i forget to write the where clause. what would be the result? It's urgent, thank you please help me quickly.

Ivan

#1
April 22, 2017, 01:05:22 PM
The result would be the Cartesian product of two tables with 20 x 10 = 200 rows.
Print
Go Up Pages1
User actions