select B.Order,B.DataTime from 表1 A ,表2 Bwhere A.PlantFlag =1 and A.CusOrder =B.AssOrderorder by B.DataTime 看看是不是这个意思
