I need to do a union query, for which there is no example in your documentation (it just says you can do it). The basic query works fine, but I also need to order the results and it doesn't seem you can do this:
select orgname oname from orgs union select acronym oname from orgs where acronym != '' order by oname
Instead, you get the error "100 Could not find field oname in the function Evaluate".
This type of syntax works, for example in Microsoft Access. Is there a technique available in Texis for order the results of a union query?
Thanks,
David
select orgname oname from orgs union select acronym oname from orgs where acronym != '' order by oname
Instead, you get the error "100 Could not find field oname in the function Evaluate".
This type of syntax works, for example in Microsoft Access. Is there a technique available in Texis for order the results of a union query?
Thanks,
David