It does wherever the column reference is or may be ambiguous (or wherever the query parser assumes it may be ambiguous!).
Try this. SELECT A.field1, B.field2, EVAL B."'TESTING'" AS field3 FROM table1 A, table2 B WHERE A.KeyField = B.KeyField; -----Original Message----- From: Shane Ricciardi <shane...@optonline.net> To: u2-users@listserver.u2ug.org Sent: Wed, Feb 16, 2011 2:52 am Subject: [U2] UniVerse/SQL: This EVAL field requires a qualifying file name Anyone ever see this error? It's happening with a SQL statement that pulls data rom a table and a "subtable", which is just an association. Something like his: ELECT field1,B.field2,EVAL 'TESTING' AS field3 FROM table1,table1_wtvr B WHERE able1.KeyField = B.KeyField; Thanks. _______________________________________________ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users