Query problem with subscriber of single number in year

[kigor]

Hello,
I go around one query problem but can't see solution.
Let me explain. I have list of person who made subscription to Arcobaleno. Arcobaleno have 10 number in one year.
When I made query I want to see what subscriber are subscribe to single number of Arcobaleno.
For example subscriber1 pay for all 2010, so from number 1 to 10 and subscriber2 pay from number 8 of 2009 to number 7 of 2010.
When I search for example number 5 of 2010 I have to receive both subscriber, but for number 8 just one.
I made query with subscriber member, start number, start year, end number, end year.
From form I receive:
looked year: [Abbonato Arcobaleno scegli numero]![ScegliAnno]
looked number: [Abbonato Arcobaleno scegli numero]![Sceglinumero]

I try lot different solution but never to receive correct number of subscriber.
Some idea?

 

[FoFa]

Re: Query problem with subsriber of single number in yeat

how about something like this, if I understand you properly:

Select xxx,xxy,xxz
From YourTable YT1
WHERE
YT1.memberNumber = LookupMemberNumber
YT1.SubscribedYear = LookUpYear
AND
LookUpNumber in (Select SubscribedNumber from yourtable YT2 where YT2.SubscribedYear = LookUpYear AND YT2.MemberNumber = YT1.MemberNumber)

 

[kigor]

unfortunate problem is little more complicated.
In subscriber table I have something like this

subscribername fromnumber fromyear tonumber toyear
subscriber1 1 2010 10 2010
subscriber2 8 2009 7 2010
subscriber3 3 2010 9 2010