SQL 2000

Three Tables

Registration
User
Line Items

I need to find the Registration ID and addresses from the Registration table
where the email address is null or empty and

Where the Registration ID in users is not the same as the one in
registration
And Where the registration_ID in line items is associated with the bank
account swim.


So in the end I want all the people who are not in the user table but also
don't have an email address in the registration table and have taken an
aquatics course.


I've tried a few things but I'm not getting accurate results.

Dan


-- 
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com


________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf

Reply via email to