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 not what I want. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
