SELECT A.COMPANY_ID, A.COUNT(APPLICANT_ID) AS APPCOUNT,B.COUNT(DEAL_ID) AS
DEALCOUNT
FROM APPLICANTS A, DEALS B
WHERE A.COMPANY_ID = B.COMPANY_ID
GROUP BY A.COMPANY_ID
CC
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
