当查询语句中同时有order by 和 union时,如果列名不相同在order by中应使用列的位置。
SELECT incase Case,inchart Chart,inbed Bed,patiname
Union
SELECT outcase Case,outchart Chart,outbed Bed,patiname
Union
SELECT incase Case,inchart Chart,inbed Bed,patiname
Order By Bed
报错:
ERROR [HY000] [Informix .NET provider][Informix]Can only use column number in ORDER BY clause with UNION.
修改后:
SELECT incase Case,inchart Chart,inbed Bed,patiname
Union
SELECT outcase Case,outchart Chart,outbed Bed,patiname
Union
SELECT incase Case,inchart Chart,inbed Bed,patiname
Order By 3
执行成功