>>>Caroline,
>>>Probably you wouldn't want to use "IN (...)", due to its limitation, right ?
>>>Assuming you first would want to get paper IDs into a cursor. ie:
>>>
>>>

>>>Create Cursor crsPapers (ItemID i)
>>>Insert into crsPapers values (1)
>>>Insert into crsPapers values (2)
>>>
>>>* ItemId 1 is The Times
>>>* ItemId 2 is The Sunday Times
>>>Select CustID from Subs s ;
>>>  left join crsPapers p on s.ItemID = p.ItemID ;
>>>  having cnt(s.ItemID) = Reccount('crsPapers') and ;
>>>	cnt(s.ItemID) = cnt(p.ItemID) ;
>>>  group by custID
>>>

>>>With an IN (lcList) it might be :
>>>
>>>

>>>* ItemId 1 is The Times
>>>* ItemId 2 is The Sunday Times
>>>lcList = '1,2'
>>>Select CustID from Subs s ;
>>> left join Papers p ;
>>> on s.ItemID = p.ItemID and p.ItemId in (&lcList) ;
>>> having cnt(s.ItemID) = Occurs(',',m.lcList)+1 and ;
>>>	cnt(s.ItemID) = cnt(p.ItemID) ;
>>> group by custID

Cetin
>>
>>Thanks Cetin that seems to work. I've just got to incorporate the new cursor into my code then I'm away.
>>Many thanks
>>Caroline
>
>Glad:) If that would be a view I think you could make that cursor parametric. ie:
>
>

>&& In command window
>Create Cursor crsPapers (ItemID i)
>Insert into crsPapers values (1)
>Insert into crsPapers values (2)
>
>m.crsPapers = 'crsPapers'
>
>create sql view as v_subs as ;
>Select CustID from Subs s ;
>  left join ?crsPapers p on s.ItemID = p.ItemID ;
>  having cnt(s.ItemID) = Reccount(?crsPapers) and ;
>	cnt(s.ItemID) = cnt(p.ItemID) ;
>  group by custID
>
>* Then once created
>m.crsPapers = sys(2015)
>select ItemID from Papers where ... into cursor (m.crsPapers) nofilter
>
>use myDB!v_subs && or requery if in use
>

Would work I 'guess' :)
>Cetin
>
>
Actually it not a view but a search query.