------------------------------
-- YPID is PK in table Clients
-- Services.YPID reference (FK) to Clients.YPID
-- Services.Date_Of DATE
-- Admissions.YPID reference (FK) to Clients.YPID
-- I hope YPID into Admissions and Services is NOT NULL
------------------------------
SELECT COUNT(YPID) FROM Clients +
WHERE YPID IN (SELECT YPID FROM Admissions +
GROUP BY YPID HAVING COUNT(YPID) > 1) +
AND YPID IN (SELECT YPID FROM Services +
WHERE Date_Of BETWEEN '02/02/2002' AND '10/02/2002')
--
RETURN
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
