tSql = SELECT c.campaign_name, c.id
FROM campaigns as c
INNER JOIN addresses_incampaign as i on (c.user_id = i.user_id)
WHERE c.user_id = prepSQL(tConn, user_id)
GROUP BY c.id;
This works when there is data in the addresses_incampaign table, but when
there is not, it returns nothing, which is
If you want the data in the campaigns table regardless if an entery exists
int he addresses_incampaign table then you should use a LEFT OUTER JOIN.
-Original Message-
From: Scott Haneda
To: MySql
Sent: 8/2/04 7:37 PM
Subject: Cant get this JOIN to work
tSql = SELECT c.campaign_name, c.id