Yes, I know it is case sensitive and I’m sure this is not the problem: the same happens on T2.AREA at the beginning and was all UPPERCASE… the problem is that I don’t know how to specify the table and the column because it returns “no such column” in any case. It seems with a different syntax it has to work…
Lets see if we can get someone from Corona to comment. Rob Miracle has a SQL background I think.
If its a Corona problem using the AS method then I guess you are down to renaming columns uniquely.
if you are not 100% you could make a sample DB and runnable code I could help verify if its Corona problem.
Another example of the problem. If I use:
SELECT * FROM transactions AS T1 INNER JOIN (app01 AS T2,app02 AS T3,transacttext AS TT) WHERE TT.LANGU = ‘E’ AND T2.LANGU = ‘E’ AND T3.LANGU = ‘E’ AND (T1.FREQ = ‘A’ OR T1.FREQ = ‘B’)
The problem is: not such column TT.LANGU
All the first part works well: SELECT * FROM transactions AS T1 INNER JOIN (app01 AS T2,app02 AS T3,transacttext AS TT) if I only write this.
The problem is when I use a table (TT), a point(.) and a Column(LANGU)
Any idea is welcome
It happens with the AS method and without the AS method. If I write directly the name of the table I have the same results. Probably renaming all the columns uniquely (as you said) could be the solution but It don´t seems very operative for a large databases. I’ll try to change all the column names…
I think its down do the use of ( and ) in the join.
SELECT * FROM transactions AS T1 INNER JOIN app01 AS T2, app02 AS T3, transacttext AS TT WHERE TT.LANGU = ‘E’ AND T2.LANGU = ‘E’ AND T3.LANGU = ‘E’ AND (T1.FREQ = ‘A’ OR T1.FREQ = ‘B’)
Try that.
It works! 
Great!
Now, I’m going to rebuild all the original query with this in mind.
Thanks another time
phew 