Union query

[chand012]

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

[John]

Which version of Texis are you using? You should be able to do that. An alternate syntax which should also work is "ORDER BY 1" to order by the first column.

[chand012]

Texis version: Commercial Version 3.01.959738425 of May 30, 2000 (sparc-sun-solaris2.5.1)

The "order by 1" syntax produces "Segmentation Fault".

[John]

You should have been shipped a newer version of Texis recently which does not have that behavior.