>
> 1. Select all email addresses (variable Email) from Table
> "condensed". ID2 is the index
>
> 2. Then the entire record for the email addresses ((variable
> Email2) table "mailist" that match the email addresses in
> Table "condensed"
>
> Code:
>
> <CFQUERY NAME="OuterLoop" DATASOURCE="BusinessDB#" DBTYPE="ODBC">
> SELECT *
> FROM condensed, maillist
> WHERE ID2 = ID2 AND Email = '#Email2#'
> </CFQUERY>
I'm not exactly sure what you're doing with those two tables, but you're not
specifying which fields come from which tables in your WHERE clause. Do both
tables have a field called ID2? Is it the primary key for one of the tables?
Is it the foreign key for the other table? If you want to select all the
email addresses from the "condensed" table, why are you filtering by email
address in your query?
It sounds to me like you'd be better served with this:
SELECT c.Email, m.*
FROM condensed c, maillist m
WHERE c.ID2 = m.ID2
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
