* This is the modus mailing list *
To get rid off Customers who no longer are using your system use the
'Closed' field in the Plans table. The query you need would become:
---
SELECT DISTINCT C.Email, C.FirstName + ' ' + C.LastName FROM Customers
AS C
INNER JOIN Plans AS P ON P.CustomerID = C.CustomerID
WHERE C.NewsFlag = 1 AND P.Closed = 0
---
This still leaves customers who are suspended or on hold in the list,
and if you want to remove them as well then you should look at the
following fields:
PaySuspended
LateSuspended
ManSuspended
I should point out you need the 'DISTINCT' keyword in the SELECT clause
otherwise you get multiple matches for customers who have more than one
plan open.
---
Another month ends. All targets met. All systems working. All customers
satisfied. All staff eagerly enthusiastic. All pigs fed and ready to
fly.
(--------------------------------) {((((((
( Suneel Jhangiani ) /_ _ )
( Technical Director ) ( . . )
( Inter-Computer Technology Ltd. ) ( / )
(----------------------------------oOOo------------oOOo----)
( 40 James Street Tel: +44 (0) 20 7486 9601 )
( London W1U 1EU Fax: +44 (0) 7050 678 978 )
( United Kingdom Email: [EMAIL PROTECTED] )
( Website: http://www.inctech.com )
(----------------------------------------------------------)
-----Original Message-----
From: Adam Woolever [mailto:[EMAIL PROTECTED]
Sent: 28 January 2004 14:57
To: [EMAIL PROTECTED]
Subject: [Modus] Mail List from Rodopi DB
* This is the modus mailing list *
Thanks for the help Suneel. I couldn't figure out what I needed exactly
for
that. I set up the query and the list filled up right away. One thing
that
I noticed also was some of the addresses listed are for people who are
no
longer with our service. To take out the non-active addresses I just
need
to add
---
WHERE PlanStatus = 1
---
I'll mess around with that part of it. Thanks again.
Adam
**
To unsubscribe, send an Email to: [EMAIL PROTECTED]
with the word "UNSUBSCRIBE" in the body or subject line.
**
To unsubscribe, send an Email to: [EMAIL PROTECTED]
with the word "UNSUBSCRIBE" in the body or subject line.
