How to fix ERPNext error?

[Samer_Adnan]

Hello… This is my first time using ERPNext, i am working on customize query for customer statement.
I used this link as reference:

Customer Statement Query

The following query can used to create to create customer statement, i am still working on the layout SELECT tA.customer AS customer_acc, tC.customer_name AS name, tA.address_line1 AS address_line1, tA.address_line2 AS address_line2, tA.city AS city, tA.country AS country, tC.default_currency AS curr, tSI.name AS trx_no, tSI.creation AS trx_date, tSI.due_date AS due_date, tSI.tc_name AS trx_type, tSI.grand_total AS trx_amount, tSI.outstanding_amount AS outs_amount FROM ((tabCustome…

but i got this error:
pymysql.err.InternalError: (1054, “Unknown column ‘tA.customer’ in ‘field list’”)
Any kind of help please.