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

WHERE T1.a = T2.a AND T1.b < 0)
Divide
(SELECT d, c
FROM T3, T4
WHERE T3.d = T4.d) ON {d}
Dividend: SELECT a, d
FROM T1, T2
WHERE T1.a = T2.a AND T1.b < 0
Divisor: SELECT d, c
FROM T3, T4
WHERE T3.d = T4.d
On: d
Replacing
(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}
with
SELECT a
FROM T1, T2
WHERE ((T1.a = T2.a) AND (T1.b < 0)) AND d IN
(SELECT d, c
FROM T3, T4
WHERE (T3.d = T4.d))
GROUP BY a
HAVING COUNT(a) =
(SELECT COUNT(*)
FROM T3, T4
WHERE (T3.d = T4.d)).
The original query now looks like:
(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)))