I have two tables in my database - one (subscribers) contains contact
information including name and email address for a list of subscribers.
The other (unsubscribers) simply contains the email address of anyone
who has unsubscribed from the list.
I'm trying to use SQL to capture all of the details of everyone in my
database as long as they haven't subscribed. I know this is going to use
Joins somehow but I can't work out how - I have an SQL book but it
doesn't seem to go into any detail about excluding one table's contents
from the results of another.
I know this is an easy one, can anybody help? Some advice on a good SQL
query guide would be really appreciated, too!
Jeff
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
