level 1
海蓝不见鲸🌊🌵
楼主
这条Sql在navicat运行正常，在jdbc中只要加上where 查询条件就没有Rs返回，求大神告知，不胜感激
，
SELECT a.Title,a.MonitorValue,a.equipmentid,b.GroupName,c.ServerAddress,c.`Port` FROM monitor a LEFT JOIN eccgroup b ON (a.GroupId = b.RecId)LEFT JOIN equipment c ON(a.EquipmentId=c.RecId) WHERE b.GroupName like '%服务器%' ORDER BY a.equipmentid
2019年10月16日 02点10分
1
，
SELECT a.Title,a.MonitorValue,a.equipmentid,b.GroupName,c.ServerAddress,c.`Port` FROM monitor a LEFT JOIN eccgroup b ON (a.GroupId = b.RecId)LEFT JOIN equipment c ON(a.EquipmentId=c.RecId) WHERE b.GroupName like '%服务器%' ORDER BY a.equipmentid
![[滑稽]](/static/emoticons/u6ed1u7a3d.png)