其实我没看懂你要什么
select a.planSequence
,a.planName
,b.deviceSequence
,b.deviceName
,c.midSequence
,c.time
表1 a,
表2 b,
表3 c
where a.planSequence=c.planSequence
and b.deviceSequence=c.deviceSequence
select a.planSequence
,a.planName
,b.deviceSequence
,b.deviceName
,c.midSequence
,c.time
表1 a,
表2 b,
表3 c
where a.planSequence=c.planSequence
and b.deviceSequence=c.deviceSequence
from a,b,c
where a.planSequence=c.planSequence
and b.deviceSequence=c.deviceSequenceHQL和SQL有区别吗 没感觉 对象就是表