SQL error running Python

[PeteJohnston]

I'm trying to write some code to use Python to create a real Excel 2010 file from one of the iSeries files. I've created a command that accepts an SQL statement and an output location as parameters. It works perfectly when only one file is involved, for example listing all transactions for a customer. When I then try to do a join to the Customer file it fails, giving me SQLState 42703, Error code -206 saying that a column is not found. It finds the field name when there is no JOIN. It finds the same field name when I cut & paste the SQL into STRSQL where it runs correctly.

SELECT CUST.CUCSNO, CUST.CUCSNM, CUST.CUAMCD, CURX.CRAN04, CUST.CUAN03 
FROM RTHAFILE.CUST INNER JOIN RTHAFILE.CURX ON CUST.CUCSNO = CURX.CRCSNO

Has anyone come across this before?

PeteJ
(Contract Code-monkey)

It's amazing how many ways there are to skin a cat
(apologies to the veggies)