Welcome Guest, Not a member yet? Register   Sign In
SQL Join is failing
#1

(This post was last modified: 08-13-2020, 11:57 AM by richb201.)

when I test this in phpMyAdmin I get       

SELECT  cc.cost_center_name,  cc.qualified_percent,  cc.qualified_percent as qualified_amount
        FROM cost_center as cc,employees as e
        WHERE e.email='$email' AND e.campaign='$campaign'
        AND cc.email='$email' AND cc.campaign='$campaign'
        LEFT OUTER JOIN cost_center ON cc.cost_center_name=e.department

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT OUTER JOIN ON cost_center ON cc.cost_center_name=e.department LIMIT 0, 25' at line 5

Any idea why?
proof that an old dog can learn new tricks
Reply


Messages In This Thread
SQL Join is failing - by richb201 - 08-13-2020, 11:06 AM
RE: SQL Join is failing - by php_rocs - 08-13-2020, 03:25 PM
RE: SQL Join is failing - by richb201 - 08-15-2020, 10:25 AM
RE: SQL Join is failing - by php_rocs - 08-15-2020, 07:28 PM
RE: SQL Join is failing - by richb201 - 08-16-2020, 09:44 AM
RE: SQL Join is failing - by php_rocs - 08-16-2020, 01:38 PM
RE: SQL Join is failing - by richb201 - 08-18-2020, 05:54 AM
RE: SQL Join is failing - by php_rocs - 08-18-2020, 06:54 AM



Theme © iAndrew 2016 - Forum software by © MyBB