Hi All
I have a sticky problem! Its a LEFT JOIN sql statement which works fine in MySQL but not when called in Perl. Any ideas?
I have 2 tables: campaigns & companies. I'm trying to join them so that all columns of both tables are returned when 2 fields match across the tables and some additional tests in the first table. It works fine in MySQL but returns an empty set when called in Perl. Is there some limitation...
Scotsman
Last Activity: Feb 18 '09, 10:36 PM
Joined: Feb 18 '09
Location:
-
Help! MySQL LEFT JOIN probelm in Perl
-
Help! MySQL LEFT JOIN probelm in Perl
Hi All
I have a sticky problem! Its a LEFT JOIN sql statement which works fine in MySQL but not when called in Perl. Any ideas?
I have 2 tables: campaigns & companies. I'm trying to join them so that all columns of both tables are returned when 2 fields match across the tables and some additional tests in the first table. It works fine in MySQL but returns an empty set when called in Perl. Is there some limitation...Last edited by Atli; Feb 18 '09, 11:33 PM. Reason: Added [code] tags and a few white spaces to make the query more readable.
No activity results to display