Urgent Help Needed

[Simonglencross]

I have created a subscription database to store subscriber and subscription
information.

I currently have a problem whereby 1 subscriber can subscribe to a number of
different ones which is fine but I want to now print off lables for everyone
interested in book 1 and 2, what is happening is that if a subscribers has
subscribed to both books 1 and 2 there details appear twice. Has anyone any
idea of how I can sort this all subscribers have a unique mailing listid can
I sort it this way some how??? any help would be much appreciated!!

Many Thanks


Simon

 

[Dan Artuso]

Hi,
You can try, Select Distinct in your query. If you're only pulling the
mailing details this should work.