⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Relationship Problem

Started by php_lover, 14 February 2013 - 07:52 AM

Single Page

php_lover

Member

Posted 14 February 2013 - 07:52 AM

When i make relation i get this error

A Database Error Occurred

Error Number: 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 'AS s29a255fe
FROM (gen_locationsetup)
LEFT JOIN `gencurrency_setup` as j29a255fe' at line 1

SELECT `gen_locationsetup`.*, j29a255fe.Currency Code AS s29a255fe
FROM (gen_locationsetup)
LEFT JOIN `gencurrency_setup` as j29a255fe ON `j29a255fe`.`Currency_Code` = `gen_locationsetup`.`Currency_Code`
LIMIT 25

Filename: C:\wamp\www\Crud\CodeIgniter_2.0.0\system\database\DB_driver.php

Line Number: 330

Dedi Triyanto

Member

Posted 16 February 2013 - 15:16 PM

You have to assure your primary key or your relation key is true and same