Mailing List Receiver wrote:
Worked under version 4. Does not work under version 5.$Qstr = "select distinct replace(reftraffic.refurl,'http://',''),\ count(*)\ from reftraffic,site\ left join links\ on left(replace(reftraffic.refurl,'http://',''),locate('/',replace(reftraffic.refurl,'http://',''))-1)\ = links.url\ where links.url is null\ and reftraffic.web = site.siteurl\ and site.vend_addr = \"$Vendor\"\ group by replace(reftraffic.refurl,'http://','')"; DBD::mysql::st execute failed: Unknown column 'reftraffic.refurl' in 'on clause' at /home/common/proj/bin/reftraffic.pl line 59.
> [[...]] FAQ, see http://dev.mysql.com/doc/refman/5.0/en/join.html Specifically, search for "precedence of the comma operator". HTH, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
