Äú²éѯµÄÊÇ: ĵ���� Õ¾µÄËùÓгµ´ÎÁÐ±í¡£
¹²ÓÐ 0 Ìõ²éѯ½á¹û
³µ´Î
³µÁ¾ÀàÐÍ
ʼ·¢Õ¾
ÖÕµãÕ¾
·¢Õ¾
·¢Ê±
µ½Õ¾
µ½Ê±
Àï³Ì
Àúʱ
select c1.theNum, c1.theType, c1.sTitle, c1.eTitle, c2.sTitle, c2.sTime, c3.sTitle, c3.eTime, c3.Mileage, c2.Mileage, c3.Days, c2.Days from Long_traininfo as c3 inner join (Long_traininfo as c2 inner join Long_trainlist as c1 on c2.theNum = c1.theNum) on c3.theNum = c1.theNum and c3.sTitle = c1.eTitle where c2.sTitle like '%ĵ����%' order by c1.theNum;