no viable alternative at input

标题 问题描述：

使用子查询时报错如下：
You have an error in your SQL syntax: no viable alternative at input ‘SELECT*FROM(SELECTequipment_id,equipment_alias,equipment_type_id,line_id,station_id,entrance_id,checkpoint_id,ip_address,port_no,create_time,equipment_statusFROMem_equipment_accessUNIONSELECTcamera_code,device_name,device_type,line_id,station_id,entrance_id,checkpoint_id,device_ip,tcp_port,create_time,statusFROMem_camera)ORDER’ near ‘[@54,529:533=‘ORDER’,<507>,29:3]’ at line 29
奇怪的是SQL直接在数据库中执行是没问题的。

标题 解决方法：

为子查询语句设置别名。