Making Query Coding in SQL Easier by Implementing the SQL Divide Keyword - Advanced Database Query Systems - page 297

FROM T3, T4
WHERE T3.d = T4.d) ON {d}) ON {a}
A divide grammar was found in the dividend:
(SELECT a, c
FROM T1, T2
WHERE ((T1.a = T2.a) AND (T1.b > 0)) AND b IN
(SELECT b, c
FROM T3, T4
WHERE (T3.d = T4.d))
GROUP BY a, c
HAVING COUNT(*) =
(SELECT COUNT(*)
FROM T3, T4
WHERE (T3.d = T4.d)))
DIVIDE
((SELECT a, d
FROM T1, T2
WHERE T1.a = T2.a AND T1.b < 0)
Divide
(SELECT d, c
FROM T3, T4
WHERE T3.d = T4.d) ON {d}) ON {a}
Dividend: SELECT a, c
FROM T1, T2
WHERE ((T1.a = T2.a) AND (T1.b > 0)) AND b IN
(SELECT b, c
FROM T3, T4
WHERE (T3.d = T4.d))
GROUP BY a, c
HAVING COUNT(*) =
(SELECT COUNT(*)
FROM T3, T4
WHERE (T3.d = T4.d))
Divisor: (SELECT a, d
FROM T1, T2
WHERE T1.a = T2.a AND T1.b < 0)
Divide
(SELECT d, c
FROM T3, T4
WHERE T3.d = T4.d) ON {d}
On: a
Another divide grammar was found in the divisor:
(SELECT a, d
FROM T1, T2