I have a database with the following information available.
MemID, Origdate, Period
the Period field can have a value of 1,2, or 3
Part of the query is
Select origdate from table where memid = @ID and perid = '3'
Problem area follows
memid = @ID and (origdate has both period = '1' and period = '2')
I am trying to find records where Memid has origdate with period 1 and same origdate with period 2