Invalid SELECT statement! Unexpected token \"Position\" at line 3, pos 40!
Posted: Sun Jun 03, 2012 2:21 pm
i see this error when i add my query
Invalid SELECT statement!
Unexpected token \"Position\" at line 3, pos 40!
this is my query
SELECT tab_employee.card_no, tab_employee.Name_emp, tab_employee.Fname_emp,
Tab_Grade.Descr_Dari AS grd, bast.Descr_Dari AS bast, tab_employee.bac_n,
tab_employee.bank_name, tab_employee.Position
FROM ((tab_employee LEFT JOIN
Tab_Grade ON tab_employee.Grade = Tab_Grade.Grade) LEFT JOIN
Tab_Grade AS bast ON tab_employee.Work_grade = bast.Grade) LEFT JOIN
Tab_Grade AS bastreform ON tab_employee.reform_post = bastreform.Grade
Invalid SELECT statement!
Unexpected token \"Position\" at line 3, pos 40!
this is my query
SELECT tab_employee.card_no, tab_employee.Name_emp, tab_employee.Fname_emp,
Tab_Grade.Descr_Dari AS grd, bast.Descr_Dari AS bast, tab_employee.bac_n,
tab_employee.bank_name, tab_employee.Position
FROM ((tab_employee LEFT JOIN
Tab_Grade ON tab_employee.Grade = Tab_Grade.Grade) LEFT JOIN
Tab_Grade AS bast ON tab_employee.Work_grade = bast.Grade) LEFT JOIN
Tab_Grade AS bastreform ON tab_employee.reform_post = bastreform.Grade