1064 - You have an error in your SQL syntax

thread_PHP

SELECT gl_account_mouvement_amount, gl_account_entry_currency_code, gl_account_mouvement_amount_reference_currency, gl_account_mouvement_transaction_type
FROM gl_account_entry
LEFT JOIN gl_account_mouvement, gl_chart_of_account ON gl_account_entry_company_id = gl_account_mouvement_company_id
AND gl_account_entry_fiscal_period_id = gl_account_mouvement_fiscal_period_id
AND gl_account_entry_journal_code = gl_account_mouvement_journal_code
AND gl_account_entry_id = gl_account_mouvement_entry_id
AND gl_account_entry_company_id = gl_chart_of_account_company_id
AND gl_account_entry_fiscal_period_id = gl_chart_of_account_fiscal_period_id
AND gl_account_mouvement_account_number = gl_chart_of_account_account_number
AND gl_account_entry_id = gl_account_mouvement_entry_id
WHERE gl_account_entry_company_id = '3'
AND gl_account_entry_fiscal_period_id = '2008'
AND gl_account_entry_date >= STR_TO_DATE( '01/01/2008', '%d/%m/%Y' )
AND gl_account_entry_date <= STR_TO_DATE( '31/12/2008', '%d/%m/%Y' )
AND gl_account_entry_state !=1
AND gl_chart_of_account_account_class_id >2
LIMIT 0 , 30

MySQL said:

#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 ' gl_chart_of_account ON gl_account_entry_company_id = gl_account_mouvement_comp' at line 1

Piranha

You have to join tables one at a time:

SELECT something 
FROM table1
JOIN table2 ON t1.id = t2.t1id
JOIN table3 ON t3.id = t1.t3id
WHERE something

thread_PHP

hi piraha
i tried its giving the same error i will send you the tables.
gl_account_entry.gl_account_entry_company_id
gl_account_mouvement.gl_account_mouvement_company_id
,
gl_chart_of_account.gl_chart_of_account_company_id
gl_chart_of_account.gl_chart_of_account_fiscal_period_id
gl_account_entry.gl_account_entry_fiscal_period_id
gl_account_mouvement.gl_account_mouvement_account_number

Piranha

The error (that is printed) is in the following line:

LEFT JOIN gl_account_mouvement, gl_chart_of_account ON gl_account_entry_company_id =

You can't join two tables at once, you have to join them one at a time.

Try that and post the new query if you can't get it running.

thread_PHP

hi piraha
please correct my query and send me. you know dotproject.net in that the generalledger installed and i get this error