asked on July 5, 2017
I'm trying to run the following query in LFQL, however I keep getting an error "An unrecognized name was encountered. [9086]" from having the period in the field name. The query runs fine without the period.
SELECT e.entry_id, p."Acct No." FROM LF.Entry e LEFT JOIN LF.Entry_Prop p ON e.entry_id = p.entry_id WHERE type='document'
I tried running with both the aliased table "p" and the non-aliased table with the same results. I am using RA 9.2 to run the query.
0
0