Consider the contents of the coiorsi and coiors2 tables.
mysql> SELECT * FROM colors1;
How many rows will be returned by the following query?
SELECT * FROM colorsl, colors2 WHERE colors2.name=’blue’
A.
0
B.
1
C.
2
D.
4
E.
8
F.
16
G.
The query will produce a syntax error because it contains no join condition.
Explanation:
Cross product join restricted by WHERE clause.