How to test the two records happened at the same time

[lrq]

I have to write a SQL to find records happened at the same time.

For example, I have a table link this
PatientID
Treatment
BeginDate
EndDate

How to write a SQL to find all the patients that have
two or more treatment at the same time. For example the
following two records are considered the valid records:
101 Detox 01/01/2004 02/15/2004
101 OutPt 01/15/2004 03/31/2004

Thanks for the help!

 

[PHV]

Something like this ?
SELECT A.*, B.*
FROM tblPatient A INNER JOIN tblPatient B ON A.PatientID=B.PatientID
WHERE A.BeginDate<=B.EndDate AND A.EndDate>=B.BeginDate

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244