Re: SQL Puzzle?

[Casey C Cook]

Does this work?

SELECT A.COMPANY_ID, A.COUNT(APPLICANT_ID),B.COUNT(DEAL_ID)
FROM APPLICANTS A, DEALS B
WHERE A.COMPANY_ID = B.COMPANY_ID
GROUP BY A.COMPANY_ID

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---